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

Which programming language is this?

WITH RECURSIVE chain (id, manager_id, depth) AS (
  SELECT id, manager_id, 0 FROM employees WHERE manager_id IS NULL
  UNION ALL
  SELECT e.id, e.manager_id, c.depth + 1
  FROM employees e JOIN chain c ON e.manager_id = c.id
)
SELECT id, depth FROM chain ORDER BY depth;

Answer: SQL

A WITH RECURSIVE common table expression whose anchor and recursive member are joined by UNION ALL is SQL.
Play Programming Languages ▸