MSSQL Day-4

To filter groups after aggregation, we use the ________ clause.

The AVG(Salary) will ignore all rows where Salary is ________.

The MAX(DateOfBirth) function returns the most ________ date.

The COUNT(*) function counts ________ rows in a table.

Which function returns the total number of records in a table?

• SUM

• COUNT

• MAX

• MIN

Which aggregate function returns the highest value?

• MIN

• SUM

• MAX

• AVG

What does AVG() return?

• Maximum value

• Minimum value

• Average value

• Total value

GROUP BY is often used with ________ functions like SUM, AVG, MAX, etc

The HAVING clause comes after the ________ clause.

What is the main purpose of the GROUP BY clause?

• Join two tablesFilter rows

• Filter rows

• Group rows based on column values

• Sort rows