Built-In Aggregate Part 1

Part of the Fundamentals section of Coddy's SQL journey — lesson 34 of 72.

There are many built-in functions in SQL but we will cover the aggregate functions in this lesson.

An aggregate function receives a field as input and calculates something over this field. The most common aggregate functions are:

You can use these functions in your SELECT statement like this:

SELECT MAX(col1), MIN(col2), AVG(col3), …

For example, to find the highest salary in an employees table:

SELECT MAX(salary) FROM employees

Or to get multiple aggregates at once:

SELECT MAX(salary), MIN(salary), AVG(salary) FROM employees

Challenge

Easy

Available tables and columns:
sales: product_id, price_per_unit, quantity

Write a query that returns:

Your result should have these exact column names:

Cheat sheet

Aggregate functions calculate values over a field. Common aggregate functions:

Use aggregate functions in SELECT statements:

SELECT MAX(col1), MIN(col2), AVG(col3) FROM table_name

Examples:

SELECT MAX(salary) FROM employees

SELECT MAX(salary), MIN(salary), AVG(salary) FROM employees

Try it yourself

Test yourself

This lesson includes a short quiz. Start the lesson to answer it and track your progress.

2Conditions

5Arithmetic Operations

8Statistics

11Window Functions part 1