MODULE 03 / LESSON 15● READY TO LEARN

Grouping

Hands-on tutorial

01 / THE CONCEPT

Understand the idea

In this lesson, explore grouping. Study the SQL example, run it in the lab when applicable, and consider how it relates to real database systems.

02 / SQL EXAMPLE

◉ example.sqlSQL

SELECT city,COUNT(*) AS total FROM students GROUP BY city HAVING COUNT(*) >= 1;

03 / KNOWLEDGE CHECK

Which statement best describes grouping?

◈

Create a free account to take the quiz and save your progress.