Recall
Set 1: Quick Check
Match aggregate functions, then compare COUNT(*) with COUNT(column).
Aggregate Functions
Summarize rows with COUNT, SUM, AVG, MIN, and MAX while handling NULL deliberately.
Start Chapter PracticeChapter plan
What you will be able to do
- Calculate and validate whole-table summaries.
- Study time
- 26–30 minutes, self-paced
- Course
- SQL for Data Analysis (Beginner)
- Practice order
- Four sets, completed in sequence
Chapter practice
Practice in chapter order
10 activities · 80% mastery target
Start set 1
Guided application
Set 2: Core Practice
Reason about NULL behavior, summary grain, and aggregate validation controls.
Hands-on
Set 3: Workplace Task
Calculate order totals and ticket completion counts in the SQL workspace.
Independent check
Set 4: Mastery Check
Predict an average with NULL and independently summarize order range.