SQL Cheat Sheet

SELECT * FROM users;SELECT name, email FROM users WHERE age > 18;SELECT * FROM users ORDER BY name ASC LIMIT 10;SELECT COUNT(*) FROM orders WHERE status = 'paid';

-- INNER JOINSELECT u.name, o.totalFROM users uINNER JOIN orders o ON u.id = o.user_id;-- LEFT JOIN (all users even without orders)SELECT u.name, o.totalFROM users uLEFT JOIN orders o ON u.id = o.user_id;

INSERT INTO users (name, email) VALUES ('Alice', 'a@x.com');UPDATE users SET email = 'new@x.com' WHERE id = 1;DELETE FROM users WHERE id = 1;