Get startedGet started for free

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.

This exercise is part of the course

Exploratory Data Analysis in SQL

View Course

Hands-on interactive exercise

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

-- Select the count of each value of revenues_change
SELECT ___, ___
  FROM ___
 ___ ___ ___
 -- order by the values of revenues_change
 ORDER BY ___;
Edit and Run Code