Interview Query

Employee Project Budgets

12
Have you seen this question before?

We’re given two tables. One is named projects and the other maps employees to the projects they’re working on.

Write a query to get the top five most expensive projects by budget to employee count ratio.

Note: Exclude projects with 0 employees. Assume each employee works on only one project.

projects table

Column Type
id INTEGER
title VARCHAR
state_date DATETIME
end_date DATETIME
budget INTEGER

employee_projects table

Column Type
project_id INTEGER
employee_id INTEGER

Output:

Column Type
title VARCHAR
budget_per_employee INTEGER
Next question: Over-Budget Projects
.....
MySQL 8.0.17
Loading editor
Use Shift + Enter to run query