Stadium with 3+ consecutive high-attendance days (SQL)

Approach: self-join with day-1 and day-2 to find any day that is the third in a window of >=100. Or use ROW_NUMBER to assign each high-attendance day an island id, group by island, filter sum>=3. Discuss the storage and indexing assumption.