# Interpolate Data — 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/4387/interpolate-data
Source observed: 2026-11-05T01:41:06.655Z
Last checked: 2026-11-05T01:41:06.655+00:00
Indexed: 2026-11-07T03:30:11.698+00:00

---

# Interpolate Data

**Difficulty:** Medium  
**Type:** SQL question

We provide this interview-style data task for practicing data cleaning and interpolation.

## Problem

You have a log of user app behavior. Some log records appear more than once, and some records have missing timestamps. The logs are recorded in chronological order. Remove duplicate records and fill missing timestamps by interpolating the data.

Because the log data is sequential, interpolation is the logical choice for filling missing `timestamp` values.

## Log schema

| Column | Type |
| --- | --- |
| `user_id` | `int` |
| `event` | `varchar` |
| `timestamp` | `datetime` |

Return the result in the same format, with no missing values.

## Workspace

The question interface includes these tabs and controls:

- **Question** — the task description.
- **Solution** — the solution area.
- **Community 0** — no community answers have been contributed.
- **Editor** and **Share** panel views.
- **Output**, **Test Results**, and **Console** areas.

Running code requires an account: [Sign up to run code](https://www.aced.io/signup?src=lesson).

[All Questions](https://www.aced.io/questions)

---

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