Aggregation, Date & Time Functions Quiz

What does the SUM() function do in SQL?

• Counts records
• Adds numeric values
• Finds max value
• Filters results

The GROUP BY clause allows SQL to apply aggregate functions to subgroups of data.

• True
• False

Which clause filters results before aggregation?

(a)  

Which clause filters results after grouping in SQL?

• WHERE
• GROUP BY
• SELECT
• HAVING

What does the COUNT(*) function return?

• The number of rows
• The number of columns
• The number of tables
• The total spend

Which function would you use to find the highest value in a column?

• MIN()
• COUNT()
• MAX()
• TOP()

What SQL clause is used to group multiple columns?

(a)  

Which of the following are valid aggregate functions in SQL?

• COUNT()
• SUM()
• FILTER()
• AVG()

Which of the following functions is used to round decimal values?

• ROUND()
• FLOOR()
• TRUNCATE()
• DIVIDE()

You can use an aggregate function in the WHERE clause.

• True
• False