# Lowest Earning Employees — SQL 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/4375/lowest-earning-employees
Source observed: 2026-11-04T23:27:47.733Z
Last checked: 2026-11-04T23:27:47.733+00:00
Indexed: 2026-11-06T09:25:17.91+00:00

---

# Lowest Earning Employees

**Difficulty:** Easy

We are Aced (formerly Exponent), an interview-preparation platform with SQL practice questions and an in-page code editor. This question asks you to write a SQL query that fetches the three employees with the lowest salaries.

## Problem

Given the following `employees` schema, return the three lowest-earning employees, including their IDs, names, and salaries:

```text
employees
+---------------+---------+
| id            | int     |
| first_name    | varchar |
| last_name     | varchar |
| salary        | int     |
| department_id | int     |
+---------------+---------+
```

Your query should produce results in this format:

```text
id | first_name | last_name | salary
---+------------+-----------+--------
int | varchar    | varchar   | int
```

The required output columns are `id`, `first_name`, `last_name`, and `salary`. The result should contain three employees with the lowest salaries.

## Practice interface

The question interface includes **Question**, **Solution**, and **Community** tabs. The editor has **Editor** and **Share** views, and the results area has **Output**, **Test Results**, and **Console** views. Code execution requires an account: [Sign up to run code](https://www.aced.io/signup?src=lesson).

No community answers have been contributed yet.

## Related questions

- [Top Earning Employees](https://www.aced.io/questions/3044/top-earning-employees)
- [Employee Earnings.](https://www.aced.io/questions/3960/employee-earnings)

## Aced interview preparation

We provide interview courses and practice across Product Management, Forward Deployed Engineering, Engineering Management, Software Engineering, System Design, Data Science, Machine Learning, and Data Engineering. Additional course areas include AI Engineering, Investment Banking, Generative AI, Security Engineering, TPM, Solutions Architecture, UX / Product Design, and BizOps & Strategy. We also provide practice questions, interview coaching, resume review, salary negotiation, job referrals, and other career resources.

- [All questions](https://www.aced.io/questions)
- [Aced home](https://www.aced.io/?src=nav)
- [Courses](https://www.aced.io/courses?src=nav)
- [Log in](https://www.aced.io/login?src=nav)
- [Sign up](https://www.aced.io/signup?src=nav)

---

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