🔹 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;

Join our WhatsApp channel: https://whatsapp.com/channel/0029VbAbnvPLSmbeFYNdNA29

👍 Tap ❤️ for more!