1. Learn
    2. /
  2. Courses
    3. /
  3. Analyzing Business Data in SQL

Exercise

Histogram of revenue

After determining that Delivr is doing well at scaling its business model, Dave wants to explore the distribution of revenues. He wants to see whether the distribution is U-shaped or normal to see how best to categorize users by the revenue they generate.

Send Dave a frequency table of revenues by user.

Instructions

100 XP
  • Store each user ID and the revenue Delivr generates from it in the user_revenues CTE.
  • Return a frequency table of revenues rounded to the nearest hundred and the users generating those revenues.