9) List the patients who do not have a prescription. The list should show the patient's name, gender, age, admission date, room, attending physician, and illness description.[Use combination of Join and nested sub query]

Construct SQL CODE queries to answer this question!

E Assignment Diagnosis lines s Medication Patient Physician E Prescription E Specialty Relationships Diagnosis lllness Patient No Illness-Code Physician ID Patient-No Role lilness Code Illness Dese Department Patient Patient No Last, Name First Name Gender Age Admit Date Bed Assignment Physician Physician_ID Last Name First Name TeLExtension Specialty ID Specielty 5peciht.ID Specialty Meditation Code Medication Desc On Hand On Order Unit Cost Prescription Pres No Patient No Medication Code Dosage