The following SQL statement would return only the non-matching rows of the left table:
SELECT FacSSN,LastName
FROM Faculty LEFT JOIN Student
ON Faculty.SSN = Student.SSN
WHERE Student.StdSSN IS NULL

Question

Quizplus · Accepted Answer

The WHERE clause filters out only the non-matching rows from the right table, which in this case is the Student table due to the LEFT JOIN. Therefore, only the rows from the left table (Faculty) that do not have a matching row in the Student table will be returned in the result set.

The Following SQL Statement Would Return Only the Non-Matching Rows