Interquartile range
The final value that Dave wants is the count of users in the revenue interquartile range (IQR). Users outside the revenue IQR are outliers, and Dave wants to know the number of "typical" users.
Return the count of users in the revenue IQR.
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 user_id and calculate revenue by user
___,
___ AS revenue
FROM meals AS m
JOIN orders AS o ON m.meal_id = o.meal_id
GROUP BY ___;