SQL

601. Human Traffic of Stadium

X city built a new stadium, each day many people visit it and the stats are saved as these columns: id, visit_date, people

Please write a query to display the records which have 3 or more consecutive rows and the amount of people more than 100(inclusive).

Note:
Each day only have one row record, and the dates are increasing with id increasing.

Logic: The three three or more consecutive indices can be {i, i-1, i-2}, {i+1, i, i-1}, {i+2, i+1, i}

LINK