Using the small sample database, 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 sub query 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.

Attachment:- database.doc