Find admissions where the province of the attending doctor (doctors.province_id) differs from the province of the patient (patients.province_id). Return the columns: admission_id, patient_id, patient_province_id, doctor_id, doctor_province_id. If the patient or the doctor has no province recorded, do not include that row. The results are sorted by admission_id in ascending order
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Compare the doctor's province with the patient's province, and drop rows where either one is missing.