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 $($Join two tables patient and bed$).$

$2.$ List all patients who had Treatments and what Treatment they received $($Join three tables Patient, Treatment, and Patient$-$Treatment$)$

$3.$ List all patients who had tests and what Test they had $($Join three tables Patient, Test, and Patient$-$Test$).$

$4.$ List the employees $($doctors$,$ nurses, etc.$)$ who assisted each patient $($Join three tables: Patient, Personnel, and Patient$-$Personnel$).$

$5.$ List all patients in alphabetical order

$6.$ List all patients who live in Atlanta and had a test completed $($Join three tables Patient, Patient$-$Test, test$).$

$7.$ List all patients who live in either Woodstock or Roswell who had a treatment completed $($Join three tables Patient, Patient$-$Treatment, treatment$).$

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.