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.
Bu egzersiz
Exploratory Data Analysis in SQL
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Select the count of each value of revenues_change
SELECT ___, ___
FROM ___
___ ___ ___
-- order by the values of revenues_change
ORDER BY ___;