Section 1 - Instruction

You've now learned the five core aggregate functions: COUNT, SUM, AVG, MIN, and MAX. It's time to put them all together to create powerful summary reports from your data.

Engagement Message

Ready to practice your new skills?

Section 2 - Practice

Type

Fill in the Blanks

Markdown With Blanks

Fill in the blanks to get a full summary of the products table: the total number of products, their average price, and the highest price of any single product.

Suggested Answers

  • COUNT
  • AVG
  • MAX
  • MIN
Section 3 - Practice

Type

Multiple Choice

Practice Question

Given a table of employee salaries, what does the following query return? SELECT MIN(salary), MAX(salary) FROM employees;

A. The number of employees and their total salary. B. The lowest and highest salary across all employees. C. The average salary and the median salary. D. An error because you can't use two aggregates at once.

Suggested Answers

  • A
  • B - Correct
  • C
  • D
Section 4 - Practice

Type

Sort Into Boxes

Practice Question

Sort these aggregate functions based on whether they also work with non-numeric data types like text or dates.

Labels

Sign up
Join the 1M+ learners on CodeSignal
Be a part of our community of 1M+ users who develop and demonstrate their skills on CodeSignal