SQL Subqueries & CASE Quiz: Boss Battle

5 timed questions to test what you learned in Subqueries & CASE: Queries Inside Queries.

What you'll be asked

A scalar subquery must return…
Predict the output: How many rows come back?
Write the query: Return the name of customers whose loyalty_points are below the average loyalty points.
Fix the bug: Fix the CASE expression.
Predict the output: What label does Meat Mountain (1800 cal) get?

Open this page in a browser to fight the boss. Score 60% or more to win.