# Improving Students

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/4384/improving-students
Source observed: 2026-11-05T01:35:10.094Z
Last checked: 2026-11-05T01:35:10.094+00:00
Indexed: 2026-11-06T19:13:16.406+00:00

---

# Improving Students

**Difficulty: Hard**

We provide this SQL interview question as an interactive coding lesson. Given the schema below, write a function to find students who have consistently improved academically throughout the years.

## Input schema

| Column | Type |
| --- | --- |
| `student_id` | `int` |
| `year` | `int` |
| `class` | `varchar` |
| `yearly_gpa` | `float` |

## Required output

| Column | Type |
| --- | --- |
| `student_id` | `int` |
| `2021` | `float` |
| `2022` | `float` |
| `2023` | `float` |
| `average_gpa` | `float` |

Requirements:

- Populate the `2021`, `2022`, and `2023` columns with the respective yearly GPAs.
- Round `average_gpa` to the nearest 2 decimal places.
- Return students whose academic performance consistently improved throughout the years.

## Interactive lesson controls

The lesson includes **Question**, **Solution**, and **Community3** tabs. The coding workspace provides **Editor** and **Share** views, plus **Output**, **Test Results**, and **Console** tabs. The execution control is disabled until the required access is available; [sign up to run code](https://www.aced.io/signup?src=lesson).

## Related question

- [Improve StubHub.](https://www.aced.io/questions/2609/improve-stubhub-strategies)

---

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