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.
Diese Übung ist Teil des Kurses
<Kurs>Analyzing Business Data in SQL</Kurs>Interaktive praktische Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
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;