A. Find the names of all students who are friends with someone named Homer J. Simpson.

B. For every pair of students who both like each other, return the name and status of both students.

C. Find all students who do not appear in the Likes table (as a student who likes or is liked) and return their names and status. Sort by status, then by name within each status.

D. For every situation where student A likes student B,but we have no information about whom B likes (that is, B does not appear as an ID1 in the Likes table),return A and B's names and status.

Transcribed Image Text:

For the following relation schema: Students(ID, name, status) Grade History(ID.courseID, course Credit, grade_point) Friend(ID1,ID2) Likes (ID1, ID2) Friend table represents unidirectional relationships i.e if id1 = 1510 and id2 = 1381 means 1510 friends with 1381 but not vice versa. Likes table represents unidirectional relationships i.e if id1 = 1689 and id2 = 1709 means 1689 Likes 1709 but not vice versa. The four years of undergraduate education are called: freshman, sophomore, junior, Senior. Students Friend Likes GradeHistory ID name ID1 1025 Rick 1101 1510 1689 ID2 ID1 1510 1381 1689 ID2 ID courseID courseCredit grade point year semester 1709 1025 CSE311L 0 0.00 2020 FALL Jerry 1689 1709 1709 1689 1025 CSE311 3 3.00 2020 FALL 1247 Shaggy Rogers 1381 1247 1782 1709 1304 CSE311L 0 0.00 2020 FALL 1304 Winnie the Pooh 1709 1247 1911 1304 CSE311L 3 3.00 2020 FALL 1247 1316 Leonardo 1689 1782 1316 CSE311L 0 0.00 2020 FALL 1247 1468 1782 1468 1381 Charlie Brown and Snoopy 1316 CSE311L 3 4.00 2020 FALL 1782 1316 1641 1468 1468 CSE311L 0 0.00 2020 FALL 1468 Mickey Mouse 1782 1501 Raphael 1510 Bugs Bunny 1304 1316 1468 1101 1501 1468 1641 1934 1304 1468 CSE311L 3 3.30 2020 FALL 1934 1501 CSE311L 0 0.00 2020 FALL 1501 1641 Scooby-Doo 1101 1641 1247 1911 1501 CSE311L 3 2.70 2020 FALL 1025 1101 1641 CSE311L 0 0.00 2020 FALL 1661 Scrooge McDuck 1247 1501 1641 CSE311L 3 3.70 2020 FALL 1689 Homer J. Simpson 1911 1501 1709 Tom 1501 1934 1316 1934 1782 Doremon 1934 1304 1911 Homer J. Simpson 1304 1661 1934 Morty 1661 1025 Write an expression in SQL for each of the following queries: For the following relation schema: Students(ID, name, status) Grade History(ID.courseID, course Credit, grade_point) Friend(ID1,ID2) Likes (ID1, ID2) Friend table represents unidirectional relationships i.e if id1 = 1510 and id2 = 1381 means 1510 friends with 1381 but not vice versa. Likes table represents unidirectional relationships i.e if id1 = 1689 and id2 = 1709 means 1689 Likes 1709 but not vice versa. The four years of undergraduate education are called: freshman, sophomore, junior, Senior. Students Friend Likes GradeHistory ID name ID1 1025 Rick 1101 1510 1689 ID2 ID1 1510 1381 1689 ID2 ID courseID courseCredit grade point year semester 1709 1025 CSE311L 0 0.00 2020 FALL Jerry 1689 1709 1709 1689 1025 CSE311 3 3.00 2020 FALL 1247 Shaggy Rogers 1381 1247 1782 1709 1304 CSE311L 0 0.00 2020 FALL 1304 Winnie the Pooh 1709 1247 1911 1304 CSE311L 3 3.00 2020 FALL 1247 1316 Leonardo 1689 1782 1316 CSE311L 0 0.00 2020 FALL 1247 1468 1782 1468 1381 Charlie Brown and Snoopy 1316 CSE311L 3 4.00 2020 FALL 1782 1316 1641 1468 1468 CSE311L 0 0.00 2020 FALL 1468 Mickey Mouse 1782 1501 Raphael 1510 Bugs Bunny 1304 1316 1468 1101 1501 1468 1641 1934 1304 1468 CSE311L 3 3.30 2020 FALL 1934 1501 CSE311L 0 0.00 2020 FALL 1501 1641 Scooby-Doo 1101 1641 1247 1911 1501 CSE311L 3 2.70 2020 FALL 1025 1101 1641 CSE311L 0 0.00 2020 FALL 1661 Scrooge McDuck 1247 1501 1641 CSE311L 3 3.70 2020 FALL 1689 Homer J. Simpson 1911 1501 1709 Tom 1501 1934 1316 1934 1782 Doremon 1934 1304 1911 Homer J. Simpson 1304 1661 1934 Morty 1661 1025 Write an expression in SQL for each of the following queries:

Answer rating: 100% (QA)

Here are the SQL expressions for each of the queries A Find the names of all students who are friend... View the full answer