#include <stdio.h>
DATABASE PERS = FILENAME "PERSONNEL";
main()
{
READY PERS;
START_TRANSACTION READ_ONLY;
FOR E IN EMPLOYEES
SORTED BY E.FIRST_NAME
WITH UNIQUE D IN DEGREES WITH D.EMPLOYEE_ID = E.EMPLOYEE_ID
printf("%s %s has one and only one college degree.\n",
E.FIRST_NAME, E.LAST_NAME);
END_FOR;
COMMIT;
FINISH;
}