$ ./guess_the_languageProgramming Languages
Programming Languages · hard · #563

Which programming language is this?

SELECT name,
  CASE
    WHEN score >= 90 THEN 'A'
    WHEN score >= 75 THEN 'B'
    ELSE 'C'
  END AS grade
FROM students
WHERE id IN (SELECT student_id FROM enrollments);

Answer: SQL

A CASE WHEN ... THEN ... END AS column plus a WHERE id IN (SELECT ...) subquery is SQL.
Play Programming Languages ▸