1. Learn
  2. /
  3. Courses
  4. /
  5. Exploratory Data Analysis in SQL

Exercise

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.

Instructions 1/3

undefined XP
    1
    2
    3
  • Use GROUP BY and count() to examine the values of revenues_change.
  • Order the results by revenues_change to see the distribution.