✅ Top SQL Queries: Part-1 🧠💻

1️⃣ SELECT – Retrieve Data
🔹 Use case: Show all employees
SELECT * FROM employees;

2️⃣ WHERE – Filter Data
🔹 Use case: Get employees from ‘Sales’ department
SELECT name FROM employees WHERE department = 'Sales';

3️⃣ ORDER BY – Sort Results
🔹 Use case: List products by price (low to high)
SELECT product_name, price FROM products ORDER BY price ASC;

4️⃣ GROUP BY – Aggregate Data
🔹 Use case: Count employees in each department
SELECT department, COUNT(*) FROM employees GROUP BY department;

5️⃣ JOIN – Combine Tables
🔹 Use case: Show orders with customer names
SELECT o.order_id, c.customer_name
FROM orders o
JOIN customers c ON o.customer_id = c.id;

6️⃣ INSERT – Add New Records
🔹 Use case: Add a new product
INSERT INTO products (name, price, category)
VALUES ('Headphones', 1500, 'Electronics');

7️⃣ UPDATE – Modify Existing Records
🔹 Use case: Change price of 'Headphones'
UPDATE products SET price = 1700 WHERE name = 'Headphones';

8️⃣ DELETE – Remove Data
🔹 Use case: Delete users inactive for 1 year
DELETE FROM users WHERE last_login < '2024-01-01';

9️⃣ LIKE – Pattern Matching
🔹 Use case: Find customers whose names start with 'A'
SELECT * FROM customers WHERE name LIKE 'A%';

🔟 LIMIT – Restrict Output
🔹 Use case: Show top 3 most expensive items
SELECT name, price FROM products ORDER BY price DESC LIMIT 3;

💬 Tap ❤️ for Part 2!