$ ./guess_the_languageProgramming Languages
Programming Languages · medium · #597

Which programming language is this?

SELECT p.name, COALESCE(SUM(s.qty), 0) AS sold
FROM products p
LEFT JOIN sales s USING (product_id)
GROUP BY p.name;

Answer: SQL

A LEFT JOIN ... USING (product_id) with COALESCE(SUM(...), 0) and GROUP BY is SQL.
Play Programming Languages ▸