Playground

Run SQL in your browser

A real SQLite engine with 29 tables across four sample databases. Nothing to install, nothing leaves your device.

SELECT c.name, COUNT(o.order_id) AS orders, ROUND(SUM(o.total_amount), 2) AS spent
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.customer_id
GROUP BY c.name
ORDER BY spent DESC;

Press ⌘↵ (or Ctrl↵) to run. Results show up here.

Every run starts from a fresh copy of the database, so go ahead and DELETE things.