4. Find the names of patients who have a prescription that contains the medicine called Panadol. 5. Find the average price of medicines 6. Find total price of medicines prescribed for a patient called...

What is the solution for this question (using sql queries)

Extracted text: 4. Find the names of patients who have a prescription that contains the medicine called Panadol. 5. Find the average price of medicines 6. Find total price of medicines prescribed for a patient called Adam. 7. Find the names of the patients who have prescriptions from the 'Well Nutrition' clinic 8. Find the maximum price of a medicine


Extracted text: Problem 4: SQL Queries Consider the following Relational schema and Relations instances. Patient (ID:char(9), p_name:varchar(25), City: varchar(50)) Prescription (Patient_ID:char(9), Medicine_code:char(5), Clinic:varchar(25)) Medicine (code:char(5), m_name:varchar, Ingredients:varchar, Price:float ) Patient Prescription ID P_name City Patient ID Medicine code Clinic 112233445 Adam Beirut 112233445 Nx306 Well Nutrition 998877665 Bob Saida 112233445 Pa003 Healthy Clinic 556677889 Sara Zahle 998877665 Pa003 Safe Clinic 443322445 Eve Туre 443322445 Ad500 Safe Clinic 443322445 Nx306 Well Nutrition Medicine code M_name Ingredients Price Pa003 Panadol Potassium, Paracetamol, Starch 5.5 Nx306 Nexume Magnesium, Polysorbate, Glyceryl 20.0 Ad500 Adol Acetaminophen, Paracetamol 3.0 Aр800 Aspirin Acetysalicylic Acid, Starch 8.55