(Solved) : Database Lab Using Sql Select Statements Query Database Tables Turning Results Following Q Q30683101 . . . .

Database

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

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

2. List all patients who had Treatments and what Treatment theyreceived

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

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

5. List all patients in alphabetical order

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

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

If you don’t have data in