🔹 Top 10 SQL Functions/Commands Commonly Used in Data Analysis 📊

1️⃣ SELECT
– Used to retrieve specific columns from a table.
SELECT name, age FROM users;

2️⃣ WHERE
– Filters rows based on a condition.
SELECT × FROM sales WHERE region = 'North';

3️⃣ GROUP BY
– Groups rows that have the same values into summary rows.
SELECT region, SUM(sales) FROM sales GROUP BY region;

4️⃣ ORDER BY
– Sorts the result by one or more columns.
SELECT * FROM customers ORDER BY created_at DESC;

5️⃣ JOIN
– Combines rows from two or more tables based on a related column.
SELECT a.name, b.salary
FROM employees a
JOIN salaries b ON a.id = b.emp_id;

6️⃣ COUNT() / SUM() / AVG() / MIN() / MAX()
– Common aggregate functions for metrics and summaries.
SELECT COUNT(×) FROM orders WHERE status = 'completed';

7️⃣ HAVING
– Filters after a GROUP BY (unlike WHERE, which filters before).
SELECT department, COUNT() FROM employees GROUP BY department HAVING COUNT() > 10;

8️⃣ LIMIT
– Restricts number of rows returned.
SELECT * FROM products LIMIT 5;

9️⃣ CASE
– Implements conditional logic in queries.
SELECT name,
CASE
WHEN score >= 90 THEN 'A'
WHEN score >= 75 THEN 'B'
ELSE 'C'
END AS grade
FROM students;

🔟 DATE functions (NOW(), DATE_PART(), DATEDIFF(), etc.)
– Handle and extract info from dates.
SELECT DATE_PART('year', order_date) FROM orders;

💬 Tap ❤️ for more!