Introduction

SQL lets you query relational data. Focus on reading data before writing mutations.

SELECT

SELECT id, name FROM users;

WHERE

SELECT * FROM users WHERE country = 'IN' AND active = true;

JOIN

SELECT o.id, u.name
FROM orders o
JOIN users u ON u.id = o.user_id;

GROUP BY

SELECT country, COUNT(*) AS users
FROM users
GROUP BY country
ORDER BY users DESC;

Practice

Try rewriting these queries for your own schema to build intuition.