Except (SQL)

We can use EXCEPT to subtract the results of one query from another:

(SELECT SSN FROM EMPLOYEE)
EXCEPT
(SELECT ESSN AS SSN FROM WORKS_ON WHERE PNO=1)