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 ID1 is friends with the TA with ID2. Friendship is mutual, so if (123,456) is in the Friend table, so is (456, 123). REVIEW_TA (ID1, ID2) English: The TA with ID1 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 TAs' 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 Kashfia 10 Chandra 9 3. For each situation where TA X reviews TA Y, and TA Y reviews different TA Z, return the result in following format X reviews Y, and Y reviews Z", and rename the column as Message. Message Ananna reviews Chandra, and Chandra reviews Gazi Gonesh reviews Alamin and Alamin reviews Kashfia 4. Return the average number of friends per TA? (Your result should be just one number.) Hint: Read the description of FRIEND table again to find out the mutual status. AVG Friend 2.5000 5. Find all TAs' who do not appear in the review_ta table (as a TA who likes or is liked) and return their names and grades. Sort by gpa, then by name. name = 2gpa - 1 Jahid 3.36 Laila 3.66 Tania 3.66 6. Find the number of TAs who are either friends with Chandra or are friends of friends of Chandra. (Do not count Chandra, even though technically she is a friend of a friend). COUNT(") 7 7. Minimum Requirement for UGA is having GPA 3.3, and for GA is 3.5. However, Department may consider special cases by relaxing the minimum requirement a bit. Find out the name and position of TA 1 TO 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 ID1 is friends with the TA with ID2. Friendship is mutual, so if (123,456) is in the Friend table, so is (456, 123). REVIEW_TA (ID1, ID2) English: The TA with ID1 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 TAs' 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 Kashfia 10 Chandra 9 3. For each situation where TA X reviews TA Y, and TA Y reviews different TA Z, return the result in following format X reviews Y, and Y reviews Z", and rename the column as Message. Message Ananna reviews Chandra, and Chandra reviews Gazi Gonesh reviews Alamin and Alamin reviews Kashfia 4. Return the average number of friends per TA? (Your result should be just one number.) Hint: Read the description of FRIEND table again to find out the mutual status. AVG Friend 2.5000 5. Find all TAs' who do not appear in the review_ta table (as a TA who likes or is liked) and return their names and grades. Sort by gpa, then by name. name = 2gpa - 1 Jahid 3.36 Laila 3.66 Tania 3.66 6. Find the number of TAs who are either friends with Chandra or are friends of friends of Chandra. (Do not count Chandra, even though technically she is a friend of a friend). COUNT(") 7 7. Minimum Requirement for UGA is having GPA 3.3, and for GA is 3.5. However, Department may consider special cases by relaxing the minimum requirement a bit. Find out the name and position of TA 1 TO
