(Solved): PART B3: SQL DATA MANIPULATION LANGUAGE (5 points) The tables (i.e., Doctor, Patient, Billing) deri ...

PART B3: SQL DATA MANIPULATION LANGUAGE (5 points) The tables (i.e., Doctor, Patient, Billing) derived from the ER-Diagram shown above form part of a relational database for a hospital system. Generate the SQL statements for the following queries: 1. For every oncologist, list the doctor's name and total number of patients under their care. This list must only include for those doctors with at least 10 patients. 2. Use subqueries. Find all the doctors with expertise either in cardiology or hematology, and whose patients with pending payment to the hospital of more than RM 10,000. 3. Find the top three patients with the highest number of hospital bills sent to them from the finance department in descending order. For each patient, your results must include the patient number, name, and the total number of hospital bills. 4. Maryam is the patient of Dr Aishah (a gynecologist). She had cancelled her next appointment with Dr Aishah due to Covid. Find other patients of Dr Aishah that can replace her.