Using the small sample database you created for Dr. Z in Case Exercise 1 in Chapter 6, write queries that illustrate the more complex queries covered in this chapter:

a. Select information from two or more tables (e.g., all the details of all the visits of a patient, etc.).

b. Use subquery syntax (e.g., a listing of all the patients who reported pain that exceeded the average pain for all visits).

c. Return a result table that could be used to produce a report, sorted by patient name or date, for a particular week or after a particular date, or a listing of patient visits for patients assigned to a specific social worker.