SQL cheatsheet

Syntax snippets and quick notes for revision.

SQL Introduction

SELECT customer, total, status
FROM orders
WHERE total >= 50
ORDER BY total DESC;

Use this sql introduction pattern when a SQL task needs a small, readable starting point.

SELECT customer, total, status
FROM orders
WHERE total >= 51
ORDER BY total DESC;

Use this select pattern when a SQL task needs a small, readable starting point.

SELECT customer, total, status
FROM orders
WHERE total >= 52
ORDER BY total DESC;

Use this where pattern when a SQL task needs a small, readable starting point.

SELECT customer, total, status
FROM orders
WHERE total >= 53
ORDER BY total DESC;

Use this order by pattern when a SQL task needs a small, readable starting point.

SELECT customer, total, status
FROM orders
WHERE total >= 54
ORDER BY total DESC;

Use this limit pattern when a SQL task needs a small, readable starting point.

INSERT INTO orders (customer, total, status)
VALUES ('Asha', 55, 'paid');

Use this insert pattern when a SQL task needs a small, readable starting point.

UPDATE orders
SET status = 'refunded'
WHERE id = 42 AND status = 'paid';

Use this update pattern when a SQL task needs a small, readable starting point.

SELECT customer, total, status
FROM orders
WHERE total >= 57
ORDER BY total DESC;

Use this delete pattern when a SQL task needs a small, readable starting point.

SELECT status, COUNT(*) AS orders, SUM(total) AS revenue
FROM orders
GROUP BY status
HAVING SUM(total) >= 58;

Use this group by pattern when a SQL task needs a small, readable starting point.

SELECT status, COUNT(*) AS orders, SUM(total) AS revenue
FROM orders
GROUP BY status
HAVING SUM(total) >= 59;

Use this having pattern when a SQL task needs a small, readable starting point.

SELECT customers.name, orders.total
FROM customers
JOIN orders ON orders.customer_id = customers.id
WHERE orders.status = 'paid';

Use this join pattern when a SQL task needs a small, readable starting point.

SELECT customer, total, status
FROM orders
WHERE total >= 61
ORDER BY total DESC;

Use this subqueries pattern when a SQL task needs a small, readable starting point.