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