SQL Gym - SQLite

Run SQL queries instantly in your browser.

-- SQLite Demo Query
-- Tables: users, orders
SELECT 
  u.name, 
  u.email, 
  COUNT(o.id) as order_count
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
GROUP BY u.id, u.name, u.email
ORDER BY order_count DESC;

Output

ready Click RUN to execute 0