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

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; don't use any aliases here.
  • 2
    • Repeat Step 1, but this time, creating a grouped summary of profits by sector, ordering the results by the average profits for each sector; don't use any aliases here.