Scenario SQL Question
Hire Year Analysis
Build mastery in Aggregations with this scenario-based SQL challenge and live execution support.
Problem Statement
For each year in which someone was hired, return hire_year, employees_hired, and avg_salary (rounded to 2 decimals). Sort by hire_year ascending.
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: