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

To find dates with at least three consecutive days of attendance over 100, you can use a window function like LAG or LEAD to check attendance on preceding and succeeding days.

1. Identify qualifying days: First, filter the attendance records to include only days where attendance was 100 or more.
2. Check for consecutive days: Use LAG to get the attendance of the previous day and LEAD to get the attendance of the next day.
3. Count consecutive days: For each qualifying day, check if the previous day and the day before that also had attendance of 100 or more. If so, this day is the third day of a consecutive streak.
4. Group and filter: Group the results by stadium and date, and then filter for groups where at least three consecutive days meet the criteria.

Alternatively, you can use self-joins to compare dates and check for consecutive sequences.