Main content
Course: Unlisted resources area > Unit 2
Lesson 3: SQL documentation- SQL: CREATE table with multiple data types
- SQL: CREATE table with a primary key
- SQL: Specifying DEFAULT values in CREATE TABLE
- SQL: CREATE TABLE with foreign key reference
- SQL: INSERTing values in tables
- SQL: SELECTing rows
- SQL: SELECTing with WHERE conditions
- SQL: Filter with IN
- SQL: SELECT with ORDER BY
- SQL: Transform SELECT results with CASE
- SQL: Filtering with LIKE
- SQL: Using SELECT with LIMIT
- SQL: ROUND and other core functions
- SQL: SELECT with aggregate functions
- SQL: Grouping SELECT results with GROUP BY
- SQL: Using HAVING with GROUP BY
- SQL: JOIN on tables
- SQL: UPDATE and DELETE
- SQL: ALTER TABLE
© 2024 Khan AcademyTerms of usePrivacy PolicyCookie Notice
SQL: SELECT with aggregate functions
SQL provides several aggregate functions for making calculations based on columns:
AVG, MAX/MIN, SUM, and COUNT. You can use those by typing the function names, then putting the column name or * inside parentheses.To eliminate duplicates sent to the function, you can type
DISTINCT before the column name inside the parentheses. This is particularly useful with COUNT, as shown before.For more details, see the SQLite reference for aggregate functions.
▶️ You can also learn about this in our Aggregating data talkthrough.