Count, Sum and Average

Talk it through with a coach who asks guiding questions and gives hints until you reach the answer. Pass to mark the challenge as completed.

The problem

  • easy
  • Pro

An orders table has a customer, an amount and a status. Explain how you'd find the number of orders, the total revenue and the average order value, and how counting all rows differs from counting a column that is sometimes empty.

Talk this problem through with an AI coach

This is a Pro challenge. Sign in with Google, then upgrade to start a voice session.

Start free →