Learn Practice Problems Arena Leaderboard

SQLab — learn SQL in your browser

Learn Practice Problems Arena Leaderboard

SQLab

Average pay by department

MediumIT companyAVG40 XP

Show the average salary of each department: the department name and the average salary rounded to a whole number.

Tables · IT company

departmentsDepartments8 rows

employeesEmployees87 rows

assignmentsProject assignments107 rows

projectsProjects14 rows

Sign in to open this section

Sign in to solve problems and play the arena. It takes less than a minute.

SQLab

Tables · IT company

departmentsDepartments8 rows

employeesEmployees87 rows

assignmentsProject assignments107 rows

projectsProjects14 rows