This lab is used with Microsoft SQL Server Management Studio
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
OR
OR