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

Which programming language is this?

SELECT c.name, SUM(o.amount) AS spent
FROM customers c
JOIN orders o ON o.customer_id = c.id
WHERE o.created_at >= '2025-01-01'
GROUP BY c.name;

Answer: SQL

A JOIN ... ON between aliased tables with SUM(...) AS and GROUP BY is SQL.
Play Programming Languages ▸