Quick Launch (Ctrl+Q) . * SQLQuery1.sql - DESKTOP-KL269FR\SQLEXPRESS.ta_management (DESKTOP-KL269FR\88017 (54))* - Microsoft SQL Server Management Studio File Edit View Query Project Tools Window Help New Query ta_management Execute 29 | + UGA + + + + Object Explorer 4 x SQL Query1.sql - DE...L269FR\88017 (54))* + X calect * from the friend Connect - * * * th 100 % DMS Results Messages + DMS.11 id Position + ecommerce_rating 1 25 GA + employee_info 2 101 UGA employee_information 3 3 247 First_try 4 304 UGA mm 5 316 GA ta_management 6 381 UGA + Database Diagrams 468 B 7 Tables UGA System Tables 8 501 UGA File Tables 9 510 UGA # External Tables 10 641 UGA Graph Tables 11 661 UGA dbo.friend 12 689 UGA Columns 13 709 UGA ID1 (int, not nu 14 782 UGA ID2 (int, not nu 15 911 GA Keys 16 934 GA Constraints Triggers + Indexes # Statistics dbo.review_ta o Columns E ID1 (int, not nu ID2 (int, not nu # Keys Constraints > Query executed successfully. + + + DESKTOP-KL269FR\SQLEXPRESS ... DESKTOP-KL269FR\88017 ... ta_management 00:00:00 16 rows Ch 1 INS O Ready In 5 Col 1 . + + + + * SQLQuery1.sql - DESKTOP-KL269FR\SQLEXPRESS.ta_management (DESKTOP-KL269FR\88017 (54))* - Microsoft SQL Server Management Studio Quick Launch (Ctrl+Q) File Edit View Query Project Tools Window Help P. New Query 4 ta_management Execute V 89 88 87 89 Ful Object Explorer 4 x SQL Query1.sql - DE...L269FR\88017 (54))* + X calect * from the friend | Connect - * * * th 100 % DMS Results Bi Messages + DMS.11 ID Names Semester GPA + ecommerce_rating 1 25 Joyonto 12 3.55 + employee_info 2 101 Hasan 10 3.78 employee_information 3 3 247 Alamin 11 3.35 First_try 4 304 Jahangir 12 3.49 mm 5 316 Ananotara 11 ta_management 3.50 6 381 Tania 9 Database Diagrams 3.66 + 7 468 Tables Kashfia B 10 3.56 System Tables 8 501 Jessica 11 3.78 File Tables 9 510 Jahid 9 3.36 # External Tables 10 641 Britto 10 3.99 Graph Tables 11 661 Laila 12 3.66 dbo.friend 12 689 Gazi 9 3.40 Columns 13 709 Chandra 9 3.98 ID1 (int, not nu 14 782 Ananna 10 3.45 ID2 (int, not nu 15 911 Gonesh 11 3.89 Keys 16 934 Konica 12 3.29 Constraints Triggers + Indexes # Statistics dbo.review_ta o Columns ID1 (int, not nu ID2 (int, not nu # Keys Constraints > Query executed successfully. DESKTOP-KL269FR\SQLEXPRESS ... DESKTOP-KL269FR\88017 ... ta_management 00:00:00 16 rows O Ready Ln 12 Col 1 Ch 1 INS + + + + Schema: TA (ID, Name, Semester, GPA) English: There is a TA (Teaching Assistant) with ID, Name, Semester (represents in which semester he'she currently in), GPA (Current GPA) TA_INFO (ID, Position) English TA_INFO represents the position of TA (UGA - Undergraduate Teaching Assistant, GA - GRADUATE Teaching Assistant). Each TA is identified by ID Friend (IDI, ID2) English: The Ta with IDI is friends with the TA with 1D2. Friendship is mutual, so if (123,456) is in the Friend table, so is (456, 123). REVIEW_TA(IDI, ID2) English: The TA with ID reviews a TA with ID2 Reviewing someone is not necessarily mutual, so if (123. 456) is in the REVIEW_TA table, there is no guarantee that (456, 123) is also present, 1. Find the names of all As' who are friends with Gazi. Name Chandra Ananna Jahid 2. Find the name, semester of all Tas' who are reviewed by more than one other TA and the Tas' who are reviewed by other are Undergraduate Teaching Assistant Name Semester 10 Chandra 9 3. For each situation where TA X reviews TAYTA Y reviews different TA 2 retum the result in following format"X reviews and reviews Z", and rename the columnas Message Message Ananta reviews Chandia, and Chandra reubens Gazi Gunesh reviews Alerit and Alanin reviews kashfa 4. Retum dhe verge number of friends per TA? (You result should be just one number.) Hine: Read the description of FRIEND uble again to find out the mutual status AVG Friend 2.5000 5. Find all Ts' who do not appear in the review_table (as a TA who likes oe is liked) and return their names and grades Sort by spa, then by me mame spa 3.36 Lala 366 3.66 6 Find the number of TAs who are either friends with Chandra or are friends of friends of Clundra (Do o count Chandra, even though technically she is a friend of a friend) COUNTI") 7. Minimum Requirement for UGA is having GPA 3.3. and for GA is 35. However, Department may consider special cases by relaxing the minimum requirement a bit. Find out the nime and position of Quick Launch (Ctrl+Q) . * SQLQuery1.sql - DESKTOP-KL269FR\SQLEXPRESS.ta_management (DESKTOP-KL269FR\88017 (54))* - Microsoft SQL Server Management Studio File Edit View Query Project Tools Window Help New Query ta_management Execute 29 | + UGA + + + + Object Explorer 4 x SQL Query1.sql - DE...L269FR\88017 (54))* + X calect * from the friend Connect - * * * th 100 % DMS Results Messages + DMS.11 id Position + ecommerce_rating 1 25 GA + employee_info 2 101 UGA employee_information 3 3 247 First_try 4 304 UGA mm 5 316 GA ta_management 6 381 UGA + Database Diagrams 468 B 7 Tables UGA System Tables 8 501 UGA File Tables 9 510 UGA # External Tables 10 641 UGA Graph Tables 11 661 UGA dbo.friend 12 689 UGA Columns 13 709 UGA ID1 (int, not nu 14 782 UGA ID2 (int, not nu 15 911 GA Keys 16 934 GA Constraints Triggers + Indexes # Statistics dbo.review_ta o Columns E ID1 (int, not nu ID2 (int, not nu # Keys Constraints > Query executed successfully. + + + DESKTOP-KL269FR\SQLEXPRESS ... DESKTOP-KL269FR\88017 ... ta_management 00:00:00 16 rows Ch 1 INS O Ready In 5 Col 1 . + + + + * SQLQuery1.sql - DESKTOP-KL269FR\SQLEXPRESS.ta_management (DESKTOP-KL269FR\88017 (54))* - Microsoft SQL Server Management Studio Quick Launch (Ctrl+Q) File Edit View Query Project Tools Window Help P. New Query 4 ta_management Execute V 89 88 87 89 Ful Object Explorer 4 x SQL Query1.sql - DE...L269FR\88017 (54))* + X calect * from the friend | Connect - * * * th 100 % DMS Results Bi Messages + DMS.11 ID Names Semester GPA + ecommerce_rating 1 25 Joyonto 12 3.55 + employee_info 2 101 Hasan 10 3.78 employee_information 3 3 247 Alamin 11 3.35 First_try 4 304 Jahangir 12 3.49 mm 5 316 Ananotara 11 ta_management 3.50 6 381 Tania 9 Database Diagrams 3.66 + 7 468 Tables Kashfia B 10 3.56 System Tables 8 501 Jessica 11 3.78 File Tables 9 510 Jahid 9 3.36 # External Tables 10 641 Britto 10 3.99 Graph Tables 11 661 Laila 12 3.66 dbo.friend 12 689 Gazi 9 3.40 Columns 13 709 Chandra 9 3.98 ID1 (int, not nu 14 782 Ananna 10 3.45 ID2 (int, not nu 15 911 Gonesh 11 3.89 Keys 16 934 Konica 12 3.29 Constraints Triggers + Indexes # Statistics dbo.review_ta o Columns ID1 (int, not nu ID2 (int, not nu # Keys Constraints > Query executed successfully. DESKTOP-KL269FR\SQLEXPRESS ... DESKTOP-KL269FR\88017 ... ta_management 00:00:00 16 rows O Ready Ln 12 Col 1 Ch 1 INS + + + + Schema: TA (ID, Name, Semester, GPA) English: There is a TA (Teaching Assistant) with ID, Name, Semester (represents in which semester he'she currently in), GPA (Current GPA) TA_INFO (ID, Position) English TA_INFO represents the position of TA (UGA - Undergraduate Teaching Assistant, GA - GRADUATE Teaching Assistant). Each TA is identified by ID Friend (IDI, ID2) English: The Ta with IDI is friends with the TA with 1D2. Friendship is mutual, so if (123,456) is in the Friend table, so is (456, 123). REVIEW_TA(IDI, ID2) English: The TA with ID reviews a TA with ID2 Reviewing someone is not necessarily mutual, so if (123. 456) is in the REVIEW_TA table, there is no guarantee that (456, 123) is also present, 1. Find the names of all As' who are friends with Gazi. Name Chandra Ananna Jahid 2. Find the name, semester of all Tas' who are reviewed by more than one other TA and the Tas' who are reviewed by other are Undergraduate Teaching Assistant Name Semester 10 Chandra 9 3. For each situation where TA X reviews TAYTA Y reviews different TA 2 retum the result in following format"X reviews and reviews Z", and rename the columnas Message Message Ananta reviews Chandia, and Chandra reubens Gazi Gunesh reviews Alerit and Alanin reviews kashfa 4. Retum dhe verge number of friends per TA? (You result should be just one number.) Hine: Read the description of FRIEND uble again to find out the mutual status AVG Friend 2.5000 5. Find all Ts' who do not appear in the review_table (as a TA who likes oe is liked) and return their names and grades Sort by spa, then by me mame spa 3.36 Lala 366 3.66 6 Find the number of TAs who are either friends with Chandra or are friends of friends of Clundra (Do o count Chandra, even though technically she is a friend of a friend) COUNTI") 7. Minimum Requirement for UGA is having GPA 3.3. and for GA is 35. However, Department may consider special cases by relaxing the minimum requirement a bit. Find out the nime and position of