IUPUI Microsoft SQL Subqueries Worksheet

Finish the Assigned Queries using Microsoft Access:

1- List the First names and Last names of the patients who visited the health facility more than twice.

Save the query as Q1Visited.

2- Get the patient numbers and birthdays of the patients three years older than the youngest patient recorded in the birthday field.

Help: Use DATEADD() function to calculate the “3 years older than the younger person” in the Inner Query. See the structure of the function below.

DATEADD (Datepart , Number , Date)

1-Datepart is the part of the date you want to be decreased (or increased),

2-Number is the amount to decreased (or increased),

3-Date is the date to which the substruction or addition or multiplication or division will take place.

Save the query as Q2Youngest

3- Get the invoice id, paid status, and amount of those unpaid invoices whose amount is greater than the average invoice amount. Also, display the patients’ first and last names associated with the invoice.

Save the query as Q3MorethanAvarage