Post #2091

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