1. SELECT โ Retrieve data
โบ
SELECT * FROM customers;2. WHERE โ Filter rows
โบ
SELECT * FROM orders WHERE amount > 500;3. ORDER BY โ Sort results
โบ
SELECT name FROM users ORDER BY age DESC;4. GROUP BY โ Aggregate data
โบ
SELECT department, COUNT(*) FROM employees GROUP BY department;5. JOIN โ Combine tables
โบ
SELECT a.name, b.salary FROM employees a JOIN salaries b ON a.id = b.emp_id;6. INSERT INTO โ Add new data
โบ
INSERT INTO users (name, age) VALUES ('John', 30);7. UPDATE โ Modify existing data
โบ
UPDATE products SET price = 100 WHERE id = 1;8. DELETE โ Remove data
โบ
DELETE FROM logs WHERE date < '2023-01-01';9. LIKE โ Pattern matching
โบ
SELECT * FROM customers WHERE name LIKE 'A%';10. LIMIT โ Restrict result rows
โบ
SELECT * FROM sales LIMIT 10;๐ก Tip: Practice on real datasets. Learn JOIN and GROUP BY earlyโtheyโre game changers!
โจ Tap โค๏ธ if this helped you!