Summarize the distribution of numeric values
Was 2017 a good or bad year for revenue of Fortune 500 companies? Examine how revenue changed from 2016 to 2017 by first looking at the distribution of revenues_change and then counting companies whose revenue increased.
Deze oefening maakt deel uit van de cursus
Exploratory Data Analysis in SQL
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Select the count of each value of revenues_change
SELECT ___, ___
FROM ___
___ ___ ___
-- order by the values of revenues_change
ORDER BY ___;