11 12 Use the below ER Diagram and the Relational Model in the next question to answer the following SQL Questions Wor 17 18 Timele 1:59.00 ENLOVE CARE CENTER Care Center IR Care Center Name 24 Nome Nurse in Charge 27 28 Is Pator 3 34 BED bed No Roon No V Tant ASSESSMENT 10 Visto Comments Vit Pen Weg Want BP utente Vi tient Temp Is Assigned PATIENT HRN patient Name PHYSICIAN physician 10 Physician Name PHYSICIAN DX Diagnosis Date Diagnosis Time DIAGNOSIS Diagnosis Code Diagnosis Name ITEM CONSUMPTION Consume Date Consume Time Consumer Cocos ORDER Order ID Order Date Order Time ITEM Item No Item Desc nem Unit Cost TREATMENT Treatment Code Treatment Name 12 Use the below relational model and the ER diagram in the previous question to answer the following SQL Questions Time left 1:58.50 17 18 TREATMENT Tiemme 23 24 27 28 TREATMENTOR TOUR Pad Trette Tiene u 33 34 ORDE Order Order bare Tele Pet PP FIN Remesc Remnat ITEM CONSUMPTION OR Consumo Consumere Connecy Pied NATIENT Rent Putinarne Putin Name Parlie 900 DVD slo PhyName Phys. Nene PHOAN DK POUR Pro PD | PAR ( Diagnosis DAGNOSIS Durat Dugiame BED Rade Room PSM CAUECENTER Carane Nurse EMPLOYEE Emp Name Emakume ASSEMENT VO Vh Vreme Time Comment VW Time left 1:58:33 Question 26 Not yet answered Marked out of 4.00 P Flag question Write a query to display Patient First Name, Patient Last Name and admitting Physician's Last Name for all patients who have been diagnosed with Influenza (Influenza is the diagnosis name). A BIO Next page Previous page Question 27 Not yet answered Marked out of 4.00 P Flag question Write a query to answer the followng question. How many patients have been diagnosed with influenza (Influenza is the diagnosis name)? A- B 1 E E 1.1 d Next page Previous page Question 28 Not yet answered Marked out of 4.00 p Flag question The hospital administration would like to see the doctors who have admitted many patients. Write a query to display the admitting physician's id and the number of patients admitted by each physician, for those physicians who have admitted more than 10 patients. " E E 1 Next page Previous page Time left 1:58:13 Question 30 Not yet answered Marked out of 4.00 P Flag question Write a query to diplay the treatments that were not ordered to any patients yet. DE E 1 Next page Previous page Dime lelt 158,07 Question 31 Not yet answered Marked out of 4.00 P Flag question Write a query to display physician id and average item cost (itemunitcost) for each physician, if the average item cost is greater than the average item unit cost of items in Items table. B 1 DE E : 1 Next page Previous page Time left 1:58 40 Question 25 Not yet answered Marked out of 4.00 p Flag question Which patients live in Istanbul? Write a query to display all the information about the patients who live in Istanbul, Next page Previous page Question 29 Not yet answered Marked out of 4.00 p Flag question Write a query to display the maximum total payment made by a patient for consumed items. A- B1 Next page Previous page