Select
SELECT * FROM users WHERE active = 1;
Insert
INSERT INTO users (name, age) VALUES ("Dev", 25);
Update
UPDATE users SET status = "admin" WHERE id = 1;
Delete
DELETE FROM logs WHERE created_at < "2024-01-01";
Joins
SELECT * FROM users JOIN posts ON users.id = posts.user_id;
Aggregates
SELECT COUNT(*), SUM(price) FROM orders;