Need help with SQL statement homework using Access.

Here are the questions:

1. Find the oldest age, youngest age, and average age admitted into the hospital. Names of patients do not need to be listed. Give the query columns appropriate titles.

2. Produce a list of Physician IDs of all physicians who are assigned patients, sorted numerically. Also, show the number of patients to whom each physician has seen.

3. Find the age of the oldest male and female patients along with the youngest age of male and youngest age of female patients in the clinic. Hint: have one row for females and a separate row for males. Names do not need to be listed.

4. List the medication prescribed for patients who are in for Chest Pain; Show patient first and last name, gender, age, room number, medication code, and medication dosage.

[Use join query]

5. Who are the doctor(s) that are attending to Chest Pain? List the name of the doctor(s). [Write nested sub queries]

6. Produce a list of patients who were prescribed Valium. The list should contain the patient name, dosage, illness description, and the doctor's name.

[Use join query]

7. List names (first and last) and Specialty of doctors who have a patient that is in for Compound Fracture.

[Write nested sub queries]

8. List the names and IDs of doctors who have no patients.

[Use NOT IN query]

9. List the patients who do not have a prescription. The list should show the patient's number, first name, last name, gender, age, room, attending physicians first and last name, and illness description.

[Use combination of Join and nested sub query]

10. List the physicians and their specialty (first name, last name, specialty) who are assigned the role Specialty. Make sure this list is distinct.

[Use join query]

And here is the Access Database

Table Taels File Create External Data Database look Help Feids Table Ascending Y Selection Descending adSpelng Remove Sort Taggle Fit AXeeeMare cut Newoals Replace e Copy GoTo View Paste Filter Refresh Formal Painter Select Cipboard ort&Fiter Records find All Acc O E ] Assignmet Diagnosis E ness Patient Physican Medicat n Prescription Pres No Patient No Medication Cosage Click to Add 1173 PCN 5334 VIB 5558 KEF 1173 ASP 6558 VIB 7443 KEP Tables Diagnads Illness patient 6558 VAL 9248 PCN 1173 VAL physician Query2-not d.. File Creste Estemal Dats Database Tools Help Fieds Table Search 2Ascending Selection Neve 2Spelling New Copy Format Painter FilterDescending-Advanced . lol view Paste Remeve Sort Toggle Filler Refresh .All'X Delete . E-More ort & Fitter AssignmentDiagnosisilness Medication Patient_No Iliness_Code Click to Add PatientPoysician Pre Tables 1173 Assignme nt liness Medication 5883 6334 Physician 7443 Cheat Pain 8 ChildBirch TAS tament ne:s Pam 1 2 LL R 111 aeva Da coo 5 al A ACC Intl Mod dre Mller 1.035-Verz 1017 Fuiy Allis