# Overstretched Employees — 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/4382/overstretched-employees
Source observed: 2026-11-05T01:11:21.267Z
Last checked: 2026-11-05T01:11:21.267+00:00
Indexed: 2026-11-07T03:11:32.467+00:00

---

# Overstretched Employees

We provide this **Hard** coding question for **Data Analyst** candidates. It is categorized under **Coding** and **Data Analysis**.

## Problem

Given the schema below, write a solution to identify employees assigned to multiple projects that are happening at the same time.

```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                  |  |  |
+---------------+---------+  |  |  |
| id            | int     |<-+  |  +--
| name          | varchar |     +-----
+---------------+---------+

employees_projects
+---------------+---------+
| project_id    | int     |
| employee_id   | int     |
+---------------+---------+
```

## Required result

Return results in this format:

```text
department_name | employee_id | first_name | last_name | project_at_risk
----------------+-------------+------------+-----------+----------------
varchar         | int         | varchar    | varchar   | varchar (title)
```

`project_at_risk` is the project that starts later among the two or more projects an employee is working on at that time.

The page includes an interactive editor with **Editor**, **Share**, **Output**, **Test Results**, and **Console** areas. Sign up is required to run code: [Sign up to run code](https://www.aced.io/signup?src=lesson).

## Page status and access

We identify this question as having one interview and a reported last-asked time of “a year ago.” Detailed company statistics are available through [Upgrade](https://www.aced.io/upgrade?src=questions). The Community tab currently shows no contributed answers.

## Related courses

### [Data Analyst Interview Prep](https://www.aced.io/courses/data-analytics)

We help candidates prepare for data analyst interviews across product, marketing, and business analyst roles with real take-home case studies, technical and dashboarding practice, and interview strategies.

![Data Analyst Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/72OTqij57b2TklhaD2vrdV/be0dae6242904970d1696e5a4d858e18/AdobeStock_1357126576.jpeg?w=800&h=800&fm=webp&q=75)

### [SQL Interviews](https://www.aced.io/courses/sql-interviews)

We prepare candidates for SQL interviews through syntax fundamentals, aggregations, window functions, data manipulation, complex queries, and analysis across diverse datasets.

![SQL Interviews](https://images.ctfassets.net/x78yjrjc11pq/62mN54S54HpLIOmyG8qbnq/54deaf5e397d0807d71c0e27e21e5ee3/sql_illustration_2.jpg?w=800&h=800&fm=webp&q=75)

## Related question areas

- [All Questions](https://www.aced.io/questions)
- [Data Analyst questions](https://www.aced.io/questions?role=data-analyst)
- [Coding questions](https://www.aced.io/questions?type=coding)
- [Data Analysis questions](https://www.aced.io/questions?type=data-analysis)

## Aced

We are Aced, formerly Exponent. We offer interview courses, practice questions, interview coaching, resume review, salary negotiation, job referrals, and related resources for technology and analytics candidates. Our course areas include product management, forward-deployed engineering, engineering management, software engineering, system design, data science, machine learning, data engineering, AI engineering, investment banking, generative AI, security engineering, TPM, solutions architecture, UX/product design, and BizOps & Strategy.

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F4382%2Foverstretched-employees&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%2F4382%2Foverstretched-employees). Opening a form does not execute a tool.