Need Help Sql Statement Homework Using Access Questions Find Oldest Age Youngest Age Avera Q34910638

Question

Need help with SQL statement homework using Access.

Here are the questions:

  1. 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.

  1. 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.
  1. Find the age of the oldest male and female patients along withthe youngest age of male

Leave a Comment