[Solved] Lab Used Microsoft Sql Server Management Studio Lab Using Sql Select Statements Query Data Q37182671

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 whohad a treatment completed.

If you don’t have data in your created tables that will allowyou to create these queries – add appropriate data to your tablesbefore doing the queries.

Capture your results (with screenshots) from each SQLquery (SELECT statement) – that also shows the actual written query- and turn them in.

Please use the data from my previous lab.

ugge Query Designer E DEPARTMENT- BED EMPLOYEE □* (All Columns) □Eid D: (All Columns) (All Columns) □D name Reg num Bid □ room-no E name P name EEE TREATMENT Tname E Patient TEST □* (All Columns) (All Columns) □ pid *(All Columns) P name T name □Treated-person Outp. Sort Type Column Table Sort Order Filter Alias SQLQuery22.sql-,..Winn bedwar62 (58)) × E. SQLQuery14.sql .WINMbedwar62 (63))” SOLQuery9.sql – C…WIN bedwar62 (61))* Script for SelectTopNRows command from SSMS ***/ [Eid] SELECT TOP (1000) [E_name] FROM [Lab4] [dbo].[EMPLOYEE] 100 % EE ResutsMessages Ed E_name 1 274 Kitin 2 341 Sharee 3 525 Dana 863 Hay 5 3452 Alice SQLQuery 17.sql ..WINAbedwar62 (67) SQLQuery13.sql …WIN bedwar62 (62))” SQLQuery14.sql …WIN bedwar62 (63))” SQLQuery! 1 sql-…WINbedwar62 (60)) x Script for SelectTopNRows command from SSMS SELECT TOP (1000) [T_id] [T_name] FROM [Lab4]. [dbo [TEST 100 % 霝Results gil Messages T id T name 1442 Alergy 2 613 X-Ray 3 1423 Psychiatry 41753 Radiology 5 6345 Biopsy Grote או SQLQuery! 3.sgl-…WINbedwar62 (62))” > SQLQuery17.sql …WIN bedwar62 (67)) SQLQuery14.sql -.WIN bedwar62 (63))* SQLQuery11.sql ..WIM bedwar62 (60)) FROM [Lab4] [dbo].[Patient] INSERT INTO Patient (pid, P_name) VALUES (1001, Brandi), (1012, ‘Yvonne), (1014, ‘Mary, (1015, viani (1826, ‘Sarah 100% Resuts Messages pid P name 1001 Brand 2 1012 Yvonne 3 1014 Mary 41015 Wiani 5 1026 Sarah 1 Script for SelectTopNRows command from SSMS TOP [room_no] SELECT [Bid] (1000) [P name] FROM [Lab4] [dbo] [BED] INSERT İNTO BED (Bİd, room no, (01, 105,’Jarry’), (22,106,”Jake’), (03 ,107,’Ginger”),(04, 108,’ Joe’),(05, 109,’Sud.) P-name) VALUES 00% Ef Resutsl Messages Bid room_no P.name 105 Jamy 2 3 07 Ginger 3 4 108 Joe 4 5 09 Sue 5 22 106 Jake SLQuery17.sq ..WIbedwar62 (67) Lab4.sql – CSE-315…WIN bedwar62 (66)) SQLQuery 14.sql-WIN bedwar62 (63)* ESELECT TOP (10e0) [T_name] [Treated_person] FROM [Lab4].[dbo] [TREATMENT] 100 % Results gil Messages T_name Treated _person 1 Ifluenza Barbara 2 Liver surgery Ashlyn Cassady 3 NICU 4 Schizophrenia Miguel 5 Skin graft Shilene ×SO Lab4.sql- CSE-315…WINbedwar62 (66)) SQLQuery15.sgl-…WINAbedwar62 (64)) Script for SelectTopNRows command from SSMS***/ TOP [Reg_num] [D-name] SELECT (1000) FROM [Lab4]. [dbo]. [DEPARTMENT] 100% Results gil Messages D name Reg.num 1Alorah 7443 2 sa 789 3 Joe 844 4 Liam 635 5 Monae 964 Show transcribed image text ugge Query Designer E DEPARTMENT- BED EMPLOYEE □* (All Columns) □Eid D: (All Columns) (All Columns) □D name Reg num Bid □ room-no E name P name EEE TREATMENT Tname E Patient TEST □* (All Columns) (All Columns) □ pid *(All Columns) P name T name □Treated-person Outp. Sort Type Column Table Sort Order Filter Alias
SQLQuery22.sql-,..Winn bedwar62 (58)) × E. SQLQuery14.sql .WINMbedwar62 (63))” SOLQuery9.sql – C…WIN bedwar62 (61))* Script for SelectTopNRows command from SSMS ***/ [Eid] SELECT TOP (1000) [E_name] FROM [Lab4] [dbo].[EMPLOYEE] 100 % EE ResutsMessages Ed E_name 1 274 Kitin 2 341 Sharee 3 525 Dana 863 Hay 5 3452 Alice
SQLQuery 17.sql ..WINAbedwar62 (67) SQLQuery13.sql …WIN bedwar62 (62))” SQLQuery14.sql …WIN bedwar62 (63))” SQLQuery! 1 sql-…WINbedwar62 (60)) x Script for SelectTopNRows command from SSMS SELECT TOP (1000) [T_id] [T_name] FROM [Lab4]. [dbo [TEST 100 % 霝Results gil Messages T id T name 1442 Alergy 2 613 X-Ray 3 1423 Psychiatry 41753 Radiology 5 6345 Biopsy
Grote או SQLQuery! 3.sgl-…WINbedwar62 (62))” > SQLQuery17.sql …WIN bedwar62 (67)) SQLQuery14.sql -.WIN bedwar62 (63))* SQLQuery11.sql ..WIM bedwar62 (60)) FROM [Lab4] [dbo].[Patient] INSERT INTO Patient (pid, P_name) VALUES (1001, Brandi), (1012, ‘Yvonne), (1014, ‘Mary, (1015, viani (1826, ‘Sarah 100% Resuts Messages pid P name 1001 Brand 2 1012 Yvonne 3 1014 Mary 41015 Wiani 5 1026 Sarah
1 Script for SelectTopNRows command from SSMS TOP [room_no] SELECT [Bid] (1000) [P name] FROM [Lab4] [dbo] [BED] INSERT İNTO BED (Bİd, room no, (01, 105,’Jarry’), (22,106,”Jake’), (03 ,107,’Ginger”),(04, 108,’ Joe’),(05, 109,’Sud.) P-name) VALUES 00% Ef Resutsl Messages Bid room_no P.name 105 Jamy 2 3 07 Ginger 3 4 108 Joe 4 5 09 Sue 5 22 106 Jake
SLQuery17.sq ..WIbedwar62 (67) Lab4.sql – CSE-315…WIN bedwar62 (66)) SQLQuery 14.sql-WIN bedwar62 (63)* ESELECT TOP (10e0) [T_name] [Treated_person] FROM [Lab4].[dbo] [TREATMENT] 100 % Results gil Messages T_name Treated _person 1 Ifluenza Barbara 2 Liver surgery Ashlyn Cassady 3 NICU 4 Schizophrenia Miguel 5 Skin graft Shilene
×SO Lab4.sql- CSE-315…WINbedwar62 (66)) SQLQuery15.sgl-…WINAbedwar62 (64)) Script for SelectTopNRows command from SSMS***/ TOP [Reg_num] [D-name] SELECT (1000) FROM [Lab4]. [dbo]. [DEPARTMENT] 100% Results gil Messages D name Reg.num 1Alorah 7443 2 sa 789 3 Joe 844 4 Liam 635 5 Monae 964

Expert Answer

---

Answer to This lab is used with Microsoft SQL Server Management Studio For this lab you will be using SQL SELECT statements to que… . . .