"List all data from the Person table who are niether staff nor patients."
fucked if I know.
Why does
WHERE person.person_id = staff.person_id
AND person.person_id = admission.patient_id
work and
WHERE person.person_id <> staff.person_id
AND person.person_id <> admission.patient_id
not?