Database

For this lab you will be using SQL SELECT statements to query your database tables. You will be turning in the results of the following queries:

1. List all Patients and what Bed they are assigned to

2. List all patients who had Treatments and what Treatment they received

3. List all patients who had tests and what Test they had

4. List the employees (doctors, nurses, etc.) who assisted each patient.

5. List all patients in alphabetical order

6. List all patients who live in Atlanta and had a test completed

7. List all patients who live in either Woodstock or Roswell who had a treatment completed.

If you don't have data in your created tables that will allow you to create these queries - add appropriate data to your tables before doing the queries.

Capture your results from each SQL query (SELECT statement) - that also shows the actual written query - and turn them in.