Guest User

Untitled

a guest
Feb 18th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.34 KB | None | 0 0
  1. SELECT H1.name, H1.grade, H2.name, H2.grade
  2. FROM Likes l1, Highschooler h1, Highschooler H2
  3. WHERE EXISTS (
  4.   SELECT ID1, ID2
  5.   FROM Likes l2, Highschooler h3, Highschooler h4
  6.   WHERE l2.ID1=l1.ID2 AND l2.ID2=l1.ID1 AND h3.ID=l2.ID1
  7.         AND h4.Id=l2.ID2 AND h3.name>h4.name
  8. )
  9. AND h1.ID=l1.ID1 AND h2.ID=l1.ID2
  10. ORDER BY H1.name
Add Comment
Please, Sign In to add comment