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

Exercise

Summarize numeric columns

Summarize the profit column in the fortune500 table using the functions you've learned.

You can access the course slides for reference using the PDF icon in the upper right corner of the screen.

Instructions 1/2

undefined XP
  • 1
    • Compute the min(), avg(), max(), and stddev() of profits.
  • 2
    • Now repeat step 1, but summarize profits by sector.
    • Order the results by the average profits for each sector.