SQL GROUP BY Quiz: Boss Battle

5 timed questions to test what you learned in GROUP BY: Sort Into Buckets.

What you'll be asked

  • What is the difference between WHERE and HAVING?
  • Predict the output: How many rows does this return?
  • Write the query: For each specialty in chefs, return the specialty and the average hourly_wage as avg_wage.
  • Fix the bug: This query errors. Fix it so it lists cities with more than one customer.
  • Predict the output: Which category appears in the result?

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