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 8
Grouping Data (GROUP BY): Syntax and Structure
SQL SELF
Level 8,
Lesson 0
Learn how to use the
GROUP BY
operator in SQL to group data, apply aggregate functions, and build structured reports. Examples, syntax, common mistakes, and grouping quirks — everything you need to confidently work with aggregated data.
Filtering Aggregated Data with HAVING
SQL SELF
Level 8,
Lesson 1
Learn how to filter aggregated data in SQL using the HAVING operator: how it's different from WHERE, syntax, examples, and common mistakes.
WHERE vs HAVING: Execution Order Breakdown and Examples
SQL SELF
Level 8,
Lesson 2
A detailed explanation of the differences between WHERE and HAVING in SQL, the order of operations, practical examples, and common mistakes. Find out when to use WHERE, when to use HAVING, and how to properly filter rows and groups in your queries.
Numeric Functions in SQL: Rounding, Modulo, Power, and Square Root
SQL SELF
Level 8,
Lesson 3
In this lecture, you'll learn how to use the main SQL numeric functions for rounding, getting the remainder, raising to a power, and extracting the square root. We'll check out practical examples and common mistakes when working with numbers in queries.
Typical Mistakes When Working with Aggregates
SQL SELF
Level 8,
Lesson 4
Let's break down the most common mistakes when using aggregate functions in SQL: from wrong GROUP BY usage to NULL traps and query optimization.
Please enable JavaScript to continue using this application.