One of the questions asks what physicians have NOT treated Patient No. 3249. (Hint SELECT ... NOT IN ...)
I currently have a table setup with the physician_id and the patient_no. I can figure out what physicians have worked with Patient 3249 but I have no clue how to figure out what physicians haven't worked with them. The hint says use SELECT ... NOT IN ... but I haven't been able to make it work and haven't found anything online to help.
Any suggestions or pointers?