# EPA Temperature Monitoring | Aced

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/3072/epa-temperature-monitoring
Source observed: 2026-11-04T23:34:29.049Z
Last checked: 2026-11-04T23:34:29.049+00:00
Indexed: 2026-11-06T16:08:13.97+00:00

---

# EPA Temperature Monitoring

We provide interview-preparation questions and coding practice through Aced, formerly Exponent. This medium-difficulty question is categorized as **Coding** and **SQL**.

## Problem

The Environmental Protection Agency (EPA) monitors the daily temperatures of different cities to study climate change and its impact. The agency is concerned that extreme fluctuations—such as a sudden rise after a day of falling temperatures—can have adverse environmental effects.

You are given a table named `city_temperatures` with these columns:

| Column | Type | Description |
|---|---|---|
| `date` | `date` | The date of the recorded temperature. |
| `temperature` | `float` | The temperature recorded on that date. |

Write an SQL query that identifies days when the temperature rose **at least 5 degrees after falling at least 3 degrees**. Return the `date` and `temperature` for those days.

## Practice interface

The question includes Question, Solution, and Community tabs. The coding workspace provides an Editor and Share view, with Output, Test Results, and Console panels. Code execution requires an account; use [Sign up to run code](https://www.aced.io/signup?src=lesson).

Detailed company statistics for this question are available through [Upgrade](https://www.aced.io/upgrade?src=questions). The question interface also offers [Sign up](https://www.aced.io/signup?src=nav), [Log in](https://www.aced.io/login?src=nav), saving, and interview-practice actions.

## Related questions

- [Daily Temperature](https://www.aced.io/questions/7258/daily-temperature)
- [Explain temperature in LLMs](https://www.aced.io/questions/7407/explain-temperature-in-llms)

## About Aced

We offer interview courses, questions, practice, coaching, and related career resources. Our course areas include Product Management, Forward Deployed, Engineering Management, Software Engineering, System Design, Data Science, Machine Learning, Data Engineering, AI Engineering, Investment Banking, Generative AI, Security Engineer, TPM, Solutions Architect, UX / Product Design, and BizOps & Strategy. We also offer Loops, Experiences, Practice, Mock Interviews & Coaching, Resume Review, Salary Negotiation, Job Referrals, Resources, and services for universities, businesses, recruiters, and affiliates.

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

## Question metadata

- Difficulty: Medium
- Category: Coding; SQL
- Interview label: Coding
- Last asked: 3 years ago
- Community answers: None contributed yet

---

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