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

Exercise

Division

Compute the average revenue per employee for Fortune 500 companies by sector.

Instructions

100 XP
  • Compute revenue per employee by dividing revenues by employees; casting is used here to produce a numeric result.
  • Take the average of revenue per employee with avg(); alias this as avg_rev_employee.
  • Group by sector.
  • Order by the average revenue per employee.