1. 学习
    2. /
  2. 课程
    3. /
  3. Exploratory Data Analysis in SQL
Connected

练习

Division

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

说明

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.