# SQL stadium consecutive-high-attendance query

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/5088/sql-stadium-consecutive-high-attendance
Source observed: 2026-11-05T00:40:33.389Z
Last checked: 2026-11-05T00:40:33.389+00:00
Indexed: 2026-11-06T16:20:38.142+00:00

---

# Write a query to find all dates where the stadium had three or more consecutive days with attendance of 100 or more people.

We provide this SQL interview question for a Data Engineer candidate. It concerns identifying all dates belonging to a run of at least three consecutive stadium days with attendance of **100 or more people**.

The prompt is labeled **LC 601 Human Traffic of Stadium**.

## Question details

- **Role:** [Data Engineer](https://www.aced.io/questions?role=data-engineer)
- **Company:** [Amazon](https://www.aced.io/questions?company=amazon)
- **Categories:** [Coding](https://www.aced.io/questions?type=coding) and [SQL](https://www.aced.io/questions?type=sql)
- **Interview count:** 1 interview
- **Reported last asked:** 2 years ago

There are no community answers yet. Sign in or sign up to submit an answer. Detailed company statistics require [Upgrade](https://www.aced.io/upgrade?src=questions).

## Related courses

![Data Engineering Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/5XoOCgXlGqN2fa1zaroNWd/9a2e23df48a212bc00d352873feb2d6a/Data_Engineer_Interview_Prep_Hero_Image.jpg?w=800&h=800&fm=webp&q=75)

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

Prepare for data engineering roles at Meta, Google, Amazon, Microsoft, Walmart, DoorDash, and other companies with mock interviews, frameworks, senior-candidate advice, data modeling, pipeline design, SQL, coding, and behavioral interview practice.

![Behavioral Interviews: A Practical Guide for Engineers](https://images.ctfassets.net/x78yjrjc11pq/47qcoHjzFZXE37GoacedkB/9d8e3f4910d8b06b21e76745cd9cbff3/AdobeStock_1142146335.jpeg?w=800&h=800&fm=webp&q=75)

### [Behavioral Interviews: A Practical Guide for Engineers](https://www.aced.io/courses/eng-behavioral)

Prepare for senior+ behavioral interviews at FAANG and Tier-1 companies with material made with staff and principal engineers from Meta, Netflix, Google, and more. The course focuses on avoiding downleveling, elevating past projects, and sounding natural.

---

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