Get startedGet started for free

Histogram of orders

Dave also wants to plot the histogram of orders to see if it matches the shape of the histogram of revenues.

Send Dave a frequency table of orders by user.

This exercise is part of the course

Analyzing Business Data in SQL

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT
  -- Select the user ID and the count of orders
  ___,
  ___ AS orders
FROM orders
GROUP BY user_id
ORDER BY user_id ASC
LIMIT 5;
Edit and Run Code