PartiQL

Sources mentioning this language

Related languages

LLM-contributed programs

SELECT p.id, p.name, p.email, COUNT(o.id) AS order_count, SUM(o.total) AS total_spent
FROM users AS p
LEFT JOIN orders AS o ON p.id = o.user_id
WHERE p.created_at > '2020-01-01'
GROUP BY p.id, p.name, p.email
HAVING COUNT(o.id) > 0
ORDER BY total_spent DESC
LIMIT 10

Real programs from Software Heritage

No SWH evidence indexed yet for this language. (Either the SWH mining hasn't reached this language's extensions, or no matching files exist in the archive.)

Contribute — propose a file extension