Need help with SQL statement homework using Access.
Here are the questions:
- Find the oldest age, youngest age, and average age admittedinto the hospital. Names of patients do not need to be listed. Givethe query columns appropriate titles.
- Produce a list of Physician IDs of all physicians who areassigned patients, sorted numerically. Also, show the number ofpatients to whom each physician has seen.
- Find the age of the oldest male and female patients along withthe youngest age of male