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
Play Programming Languages ▸
LEFT JOIN ... USING (product_id) with COALESCE(SUM(...), 0) and GROUP BY is SQL.