# Project Budgets — SQL interview question

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/3046/project-budgets
Source observed: 2026-11-04T21:34:33.119Z
Last checked: 2026-11-04T21:34:33.119+00:00
Indexed: 2026-11-05T05:21:13.295+00:00

---

# Project Budgets

We provide this medium-difficulty SQL coding question for interview preparation. It is categorized under **Coding** and **SQL**, and is associated with **BizOps & Strategy** and **Scale AI**. The question has been reported in 2 interviews, was last asked 9 months ago, and has 34 saves. The solution is locked; community discussions show 29 contributions, while no community answers have been contributed yet.

## Question

Given the following database schema, write a query that returns every project's ID, title, budget, total number of employees assigned to the project, and the sum of those employees' salaries.

```text
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     |
+---------------+---------+           +---------------+---------+
```

The relevant project-assignment relationship is represented by `employees_projects.project_id` and `employees_projects.employee_id`. Employee compensation comes from `employees.salary`; project details come from `projects`.

Return results in this format and order them from highest to lowest total salary:

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

The page provides an interactive SQL editor with SQLite selected, plus **Output**, **Test Results**, and **Console** panels. We offer sign-up to run code: [Sign up to run code](https://www.aced.io/signup?src=lesson).

## Interview experience

One shared experience is associated with this question:

- [Scale AI · 9 months ago](https://www.aced.io/experiences/scale-ai-bizops-strategy-interview-f4b8b7) — **BizOps & Strategy**. The contributor described a rigorous, multi-stage process with substantial coordination. They noted delays between stages, one interview starting noticeably late, and fragmented communication, while describing the interviewers as professional and engaging.

## Related courses

### [Product Strategy Questions](https://www.aced.io/courses/product-strategy)

![Product Strategy Questions](https://images.ctfassets.net/x78yjrjc11pq/5hHtTyOypgyKA7R3fxMlyl/dde193ecc09baabd8304c3aec25483f2/product_strategy_course_ab4d3cf294.jpeg?w=800&h=800&fm=webp&q=75)

Product strategy is fundamentally different in the AI era, and we explain how to approach these rounds effectively within the new rules.

### [BizOps & Strategy Interview Prep](https://www.aced.io/courses/bizops)

![BizOps & Strategy Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/4UiKk2RC0mwffqXcDuADSE/aa4e742618ba2e364b78a9e2a5276c6d/bizops_track_compressed_a18a42bcca__281_29_66d3d45075.jpeg?w=800&h=800&fm=webp&q=75)

Prepare for operations and strategy roles at Google, Meta, Amazon, Uber, Microsoft, and other top companies. We offer mock interviews, frameworks, and advice from senior candidates covering strategic decision-making, stakeholder management, product strategy, analytics, and behavioral interviews.

## Related links

- [All Questions](https://www.aced.io/questions)
- [BizOps & Strategy questions](https://www.aced.io/questions?role=bizops)
- [Scale AI questions](https://www.aced.io/questions?company=scale-ai)
- [Coding questions](https://www.aced.io/questions?type=coding)
- [SQL questions](https://www.aced.io/questions?type=sql)
- [Upgrade](https://www.aced.io/upgrade?src=questions)

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3046%2Fproject-budgets&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3046%2Fproject-budgets). Opening a form does not execute a tool.