NULL Handling in Aggregate Functions

GROUP BY Fundamentals

HAVING Clause

Write a query to find total sales per day for the current month

Calculate average salary per department

Find the highest and lowest product prices in each category

What is the difference between COUNT(*) and COUNT(column)?

How do aggregate functions handle NULL values?

Can you mix aggregate and non-aggregate columns?

GROUP BY Fundamentals

NULL Handling in Aggregates

HAVING Clause