Skip to content

1623. All Valid Triplets That Can Represent a Country 👎

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
SELECT
  SchoolA.student_name AS member_A,
  SchoolB.student_name AS member_B,
  SchoolC.student_name AS member_C
FROM SchoolA, SchoolB, SchoolC
WHERE
  SchoolA.student_id != SchoolB.student_id
  AND SchoolA.student_id != SchoolC.student_id
  AND SchoolB.student_id != SchoolC.student_id
  AND SchoolA.student_name != SchoolB.student_name
  AND SchoolA.student_name != SchoolC.student_name
  AND SchoolB.student_name != SchoolC.student_name;