6)Produce a list of patients who were prescribed Valium. The list should contain the patient name, dosage, illness description, and the doctor's name. [Use join query] Construct SQL queries to answer the following questions

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