Which query finds applicants who have not yet been assigned an exam room, where assignments are in a separate RoomAssignments table?

Quelle requête trouve les candidats à qui aucune salle d'examen n'a encore été attribuée, les attributions se trouvant dans une table RoomAssignments séparée ?

Answers

ASELECT a.* FROM Applicants a JOIN RoomAssignments r ON r.ApplicantID = a.ApplicantID WHERE r.RoomNumber IS NOT NULL ORDER BY a.Name;SELECT a.* FROM Applicants a JOIN RoomAssignments r ON r.ApplicantID = a.ApplicantID WHERE r.RoomNumber IS NOT NULL ORDER BY a.Name;

BSELECT * FROM RoomAssignments WHERE ApplicantID IS NULL;SELECT * FROM RoomAssignments WHERE ApplicantID IS NULL;

CSELECT a.* FROM Applicants a LEFT JOIN RoomAssignments r ON r.ApplicantID = a.ApplicantID WHERE r.ApplicantID IS NULL;SELECT a.* FROM Applicants a LEFT JOIN RoomAssignments r ON r.ApplicantID = a.ApplicantID WHERE r.ApplicantID IS NULL;

DSELECT DISTINCT * FROM Applicants;SELECT DISTINCT * FROM Applicants;

The answer and explanation are in the full bank.

This question is one of 2,831 in the paid banks. Each comes with the correct answer and the reasoning behind it, not just a mark.

Unlock for 5,000 RWF

MIFOTRA exam practicealigned to Practice set: Database Management·3 marks·Hard

Which query finds applicants who have not yet been assigned an exam room, where assignments are in a separate RoomAssignments table?

More Database questions