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.

1 create table customer 2 3 customerid number(4) primary key, 4 companyname varchar2 (10), 5 companystreet varchar2(10), 6 companycity varchar2(10), 7 companystate varchar2 (10), 8 companyzip number (6), 9 companycontractno number(4), 10 contracttitle varchar2(10), 11 telephone varchar2 (13), 12 numberofemployees number(4) 13*) SQL> I Table created. 1 create table location 3 locationid number (4) primary key, 4 customername vcha(10), 5 street varchar2 (1) 6 city varchar2 (10), 7 state varchar2 (10), 8 companyzip number (6) 9 telephone varchar2 (12), 10 buildindsite varchar2(10) QL> I Table created