Skip to main content
All Questions

Project Budgets

Medium
Unlock detailed company stats for this questionUpgrade

Given the database with the schema shown below, write a query to fetch each project's ID, title, budget, total number of employees assigned to the project, and the sum of their salaries.

employees                             projects
+---------------+---------+           +---------------+---------+
| id            | int     |<----+  +->| id            | int     |
| first_name    | varchar |     |  |  | title         | varchar |
| last_name     | varchar |     |  |  | start_date    | date    |
| salary        | int     |     |  |  | end_date      | date    |
| department_id | int     |--+  |  |  | budget        | int     |
+---------------+---------+  |  |  |  +---------------+---------+
                             |  |  |
departments                  |  |  |  employees_projects
+---------------+---------+  |  |  |  +---------------+---------+
| id            | int     |<-+  |  +--| project_id    | int     |
| name          | varchar |     +-----| employee_id   | int     |
+---------------+---------+           +---------------+---------+

Your query should output a result in the following format, ordered by highest to lowest total salary:

id | title   | budget | num_employees | total_salaries 
----+---------+--------+---------------+----------------
int | varchar | int    | int           | int

Interview experiences

1 shared
Scale AI · 7 months ago
"The process felt quite rigorous, with multiple stages and a lot of coordination involved. There were also periods where communication felt fragmented—for example, it took some time to hear back between stages, and one of the interviews started noticeably late. While everyone I spoke with was professional and engaging, more consistent communication throughout the process would have made for a smoother candidate experience."
BizOps & Strategy

Related courses

Course

Product Strategy Questions

Product strategy is fundamentally different in the AI era, and we'll tell you exactly how to approach these rounds effectively within the new rules.

Course

BizOps & Strategy Interview Prep

Land your dream operations and strategy role at Google, Meta, Amazon, Uber, Microsoft, and other top companies. Learn from mock interviews, frameworks, and advice from senior candidates. Practice strategic decision-making, stakeholder management, product strategy, analytics, and behavioral interviews.