Create a query based on the following question

What diease(s) does patient x have?

Entities:

Patient

Staff

Doctor

Diseases

Room

Invoice

Attributes:

Patient: Patient_id (PK), First_name, Last_name, Birth_date, Age, Gender, Address, Phone_number, Email_address, Days_hospitalized(FK), Surgeries,Outpatient, Insurance_name, Insurance_number, Doctor_id (FK), Disease_id (FK)

Staff: Staff_id (PK), First_name, Last_name, Birthdate, Age, Gender, Address, Phone_number, Email_address, Salary

Doctor: Doctor_id (PK), First_name, Last_name, Gender, Phone number, Duties, Disease_id (FK), Salary

Diseases: Disease_id (PK), Disease_name, Disease_description, Disease_treatment(FK), Average_treatment_time, Disease_death_rate

Room: Room_id (PK), Room_description, Staff_id (FK), Duties

Invoice: Invoice_id (PK), Days_hospitalized(FK), Disease_treatments(FK), Surgeries, Doctor_id (FK), Patient_id (FK)

With the following information provided above -Create 3 questions and the queries that you feel that the hospital administrator, nurse, doctor, billing (basically the various functional people/department) will require.

example of what I mean

How many patients is Doctor X currently treating?

SELECT Dcotor_ID, COUNT(Patient_ID) AS total_patients FROM Patient GROUP BY Doctor_ID;