(Solved): Question 8 (SQL) - 35 marks b) Display the detail of the doctors who have the highest number of pa ...

Question 8 (SQL) - 35 marks b) Display the detail of the doctors who have the highest number of patients in The following show the tables and sample data of Bundoora Clinic. The the database. PATIENT, DOCTOR, and NATUROPATH tables store the list of patients, doctors, and naturopaths respectively. PATIENT_DOCTOR table stores the information of the relationship between patients and doctors. VISIT table c) Display the name and age of patients who have an allergy. [7 marks] stores information of patient's visit to the clinic including the medication prescribed to the patient during that visit. $$CONDITION$$ table lists possible d) Display the name of each patient in the database along with the total amount condition that patients can have. Finally PATIENT_CONDITION table of money they have paid for doctor visits. identifies what conditions that each patient has. [8 marks] e) Display the names and contact numbers of doctors and naturopaths who have at least one patient in the database. [8 marks] Write SQL statements to answer the following queries: a) Display the details of all naturopaths in the database along with his/her patient(s) (if any). Patient Name and age should be displayed. The display should be ordered by naturopath name in ascending order and then the patients should be ordered from the older patients to the younger ones.