Log in from a computer to take this course

You'll need to log in from a computer to start How to Transform Tables with SQL. But you can practice or keep up your coding streak with the Codecademy Go app. Download the app to get started.

apple storegoogle store
Learn

Aggregate functions compute a single result from a set of multiple input values. You can think of aggregate data as data collected from multiple rows at a time. In this lesson, we’ll continue learning about aggregate functions by focusing on conditionals, sums, and combining aggregate functions.

Conditional Aggregates are aggregate functions that compute a result set based on a given set of conditions.

If you are new to aggregate functions, we recommend you complete this course first.

Instructions

1.

The count function is an aggregate function, since it aggregates data from multiple rows.

Count the number of rows in the flights table, representing the total number of flights contained in the table.

Sign up to start coding

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?