kindly answer all these 3. thank you

12 Use the previous data model and the this relational schema to answer the SQL questions 18 TREATMENT Tode Tre Name 24 TREATMENT ORDER TOIR Bester TITOR TreatDate Treime Results 28 ORDER 5 Order Order Date OrderTime Iterno PR Polo 34 ITEM Item No Item Desc ItemUniCost ITEM CONSUMPTION OD ConsumeDate Consume Teme Consumeaty Patio tendo PATIENT Patient Patient Name Patient Name Patient City Admin Relerle! PHYSICIAN Phyto PhysName PhysName PHYSICIAN OX POLD Patio Php DasCode Diagnosis Date Diagnosis Time NLY PATIENT Patio Pollename Patentame Patient City Admin Mooi PHYSICIAN y! Playofame Pal Name Diagnol Time PHYSICIAN_DEX POD Patio Php Plagos Code Diagnosis Date DAGNOSIS Dingos Code Diagnosis Name ED Room No Patio Sarsfonteisid CARE CENTER Care Center Care Center Narne Nyolche EMPLOYEE [mpo Empf Name EmplName ASSESMENT VID VDate Time VComments Weight VBP VPuhe VTemp Imple Patio Timele 56 2 10 11 12 Use this data model and the following relational model to answer the Sol questions our world 15 16 17 18 CARE CENTER Care Center I are Center Name HA EMPLOYEE Emp Ne mp Name 21 22 2 Nurse In Charge 25 26 27 26 Is part of 31 22 33 14 BED bed No Room No ASSESSMENT VID Visit Date Visit Time Visit Comments Vit Patent Weight Visit Patient SP Vit Patient Pule Visit Patient Temp is assigned PATIENT MRN patient Name PHYSICIAN Physician ID - Physician Name Amit - Refers PHYSICIAN DX Diagnosis Date Diagnosis Time DIAGNOSIS Diagnosis Code Diagnosis Name ITEM CONSUMPTION Consume Date Ome Time ORDER Order 10 Order Date PATIENT HRM Patient Name PHYSICIAN Physician Physician Name Arts Rates PHYSICIAN DX Diagnosis Date Diagnosis Time DIAGNOSIS Osis Code plagnesis Name ITEM CONSUMPTION Censume Date Consume Time Consume Qty Total Cost ORDER Order 1 Order Date Order Time Treatment Treatment Time Results Consists ITEM Item No Item Desc tem Unit Cost TREATMENT Treatment Code Treatment Name Next page Previous page PATIENT HRM Patient Name PHYSICIAN Physician Physician Name Arts Rates PHYSICIAN DX Diagnosis Date Diagnosis Time DIAGNOSIS Osis Code plagnesis Name ITEM CONSUMPTION Censume Date Consume Time Consume Qty Total Cost ORDER Order ID Order Date Order Time Treatment Treatment Time Results Consists ITEM Item No Item Desc item Unit Cost TREATMENT Treatment Code Treatment Name Next page Previous page Use the previous data model and the third chama tawwer the SOCO TRARE RT M COMMON PPY Melho 2 RAVIATOR PD IMA UTE www EMONTE En AWO YO www V V Ma | vang | Train | Question 25 Not yet answered Marked out of 4.00 Flag question Write an SQL query to list all information about patients who were admitted by Physician with an Id 183. Write an SQL query to display the nurse-in-charge for the Birth Center Birth Center is the name of a Care Center Display the First Name and Last Name of the employee who is the nurse-in-charge. Question 27 Not yet answered Married out of 4.00 Flag question How many beds are occupied? Write an SQL query to list the number of beds which are assigned a patient