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),...

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

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 Ра003 Safe Clinic 443322445 Eve Тyre 443322445 Ad500 Safe Clinic 443322445 Nx306 Well Nutrition Medicine code M_name Ingredients Price Ра003 Panadol Potassium, Paracetamol, Starch 5.5 Nx306 Nexume Magnesium, Polysorbate, Glyceryl 20.0 Ad500 Adol Acetaminophen, Paracetamol 3.0 Ар800 Aspirin Acetysalicylic Acid, Starch 8.55 Write SQL queries that will do the following: 1. List the name and the ID of all patients 2. List the price of Medicine called Nexume 3. Find the names of patients who have at least one prescription. Page 6 of 7