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

Exercise

Bucketing users by orders

Dave is repeating his bucketing analysis on orders to have a more complete profile of each group. He determined that 8 orders is a good cut-off for the low-orders group, and 15 is a good cut-off for the medium orders group.

Send Dave a table of each order group and how many users are in it.

Instructions

100 XP
  • Store each user ID and its count of orders in a CTE named user_orders.
  • Set the cut-off point for the low-orders bucket to 8 orders, and set the cut-off point for the mid-orders bucket to 15 orders.
  • Count the distinct users in each bucket.