The relational schema shown below is part of a hospital database. The primary keys are underlined. Formulate SQL statements to solve parts i - iv. Patient (patientNo, patName, patAddr, DOB) Ward (wardNo, wardName, wardType, noOfBeds) Contains (patientNo, wardNo, admissionDate) Drug (drugNo, drugName, costPerUnit) Prescribed (patientNo, drugNo, unitsPer Day, startDate, finishDate) 1. List all the patients admitted today. 2. What is the total cost of Morphine supplied to a patient called 'John Smith'? 3. What is the maximum, minimum and average number of beds in a ward? Make appropriate column headings for the results table. 4. For each ward that admitted more than 10 patients today, list the ward number, ward type and number of beds in each ward.