AI Academy
Promotion
CodeGym University
Learning
Courses
Tasks
Surveys & Quizzes
Games
Help
Schedule
Community
Users
Forum
Chat
Articles
Success stories
Activity
Reviews
Subscriptions
Light theme
Lessons
Reviews
About us
Start
Start learning
Start learning now
My Progress
Courses
University
Quest Map
Lessons
SQL
SQL
Level 7
Intro to Aggregate Functions
SQL SELF
Level 7,
Lesson 0
Get to know aggregate functions in SQL: how they help you analyze huge amounts of data, count, sum up, find minimums and maximums, and also deal with missing values (NULL).
Counting Rows with
COUNT()
and Its Variations
SQL SELF
Level 7,
Lesson 1
In this lecture, you'll learn how to use the
COUNT()
function in SQL to count rows, the difference between
COUNT(*)
,
COUNT(column)
, and
COUNT(DISTINCT column)
, plus some common mistakes when working with this function.
Summing Data with SUM() — Syntax and Examples
SQL SELF
Level 7,
Lesson 2
Learn how to use the aggregate function SUM() in SQL to calculate totals for numeric columns. Syntax examples, working with conditions, handling NULL, and common mistakes — everything you need to confidently use SUM() in practice.
Averages with AVG() — calculating averages by columns
SQL SELF
Level 7,
Lesson 3
Learn how to use the aggregate function AVG() in SQL to calculate averages by columns, how it works with NULL, how to round the result, and how to filter data before calculating the average.
Minimum and Maximum Values:
MIN()
and
MAX()
SQL SELF
Level 7,
Lesson 4
Learn how to find minimum and maximum values in SQL tables using the aggregate functions
MIN()
and
MAX()
. Examples for numbers, strings, dates, and some quirks with
NULL
.
Please enable JavaScript to continue using this application.