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

//Note that not all patients have a bed.

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.

//I will add patients that live in Atlanta, Woodstock and Roswell.

100 % Routsl Messages emp id birth _date frt neme las name gender hire_date Phone Sete Zip Qualification dept id 1977-02-25 Bac 1979-06-22 Mark 1985-04-12 Matthew Benn 1976-02-21 Sarah 1977-01-15 Stella 2003-07-27 123455789 afd@ghost.com 12 Abe Lanc Maretta GA 30060 Masters in Acct 10 2005-04-11 223456789 bde@ghoet. 121 Stalo.. Manetta GA 30060 Masters in M.. 20 2005-09-12 223456789 mben@ghos121 Stalo. Merietla GA 30060 Medical Boar 40 201307-17 24656789 T@ghost.c. 162 Boar L. Atanta GA 30090 Medical Boar. 40 2006-09-12 123999789 stkoEghost.c324 Qwee. Kenn. GA 30144 PHd in Comp.5 Lin Kodenm F patient id birth_datefirstname last name gender patient dagnoss Phone Street Cty State Zp 1967-12-25 Ban Cooper M 1996-10-14 Nick 1988-02-25Kely 1981-09 22 Bacca 1988-02-25 Luhan Lung Cancer 1234 Heart Disease 7775678 nickij@yahoo.com 900 Luove Rd 56783 lafddEyahoo.com 1112 Stvebe Lane Augusa GA 31060 Marietta GA 30070 Kenne. GA 30039 lackson M 343456788 334345678 bbom@hotmail. 765 Train Avenue Maneta GA 30060 343456788 iw@gmail.com 9876 Park Stree anGA 31232 kmoon@gmai com 12 Abe Lane doctor_id doctor name Postion doctor _phone doctor_email 1234111 d@ghost.com Jchn Dolan Staff Intemist Elict Reid Attending Physician 21213259 er@ghost.com Christopher. Surpical Attendin. 12345567 ctchost.com Percival Cox Senir Attanding. 770836444 pc@ghost.c. Eob Kelso Head Chief of Me.. 523176803 bk@ghost.c. deot id dept name dept Jocation 1 10 Accounting JJ24 Research JJ20 30 Surgery JH11 40 Cardology JH13 Computer. JH21 2 20 test id test charge test duration 1500 3 21 4 3 5 33 30 minutes 50 minuto3 50 minutes 60 minutes 20 minuto3 3000.0 20.0 Code Description Date petient id doctor id