List patient_id, first_name, last_name of patients who have no record in the admissions table (their patient_id does not appear in any admissions). The displayed list is sorted by patient_id in ascending order; the column names and column order must match the expected output.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
You are looking for patients with no match in another table. Several patterns can express that.