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.