Recall
Set 1: Quick Check
Interpret arithmetic expressions, CASE boundaries, and COALESCE behavior.
Calculated Columns, CASE, and NULL
Create calculated fields, business labels, and deliberate missing-value behavior.
Start Chapter PracticeChapter plan
What you will be able to do
- Use arithmetic, CASE, and COALESCE in result expressions.
- Study time
- 28–32 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 arithmetic, safe ratios, and searched CASE evaluation.
Hands-on
Set 3: Workplace Task
Calculate line totals and assign workplace order-size labels in SQL.
Independent check
Set 4: Mastery Check
Predict a CASE result and independently create a clear missing-value display.