Leetcode SQL

601. Human Traffic of Stadium

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

For example, the table stadium:

For the sample data above, the output is:

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

Here in the problem, the “people” more than 100 meant the records with people more than 100, which is the single record, not the sum of the records.\

The use the three possible combination of id’s for the ids in the outcome table

Related posts:

I was up before the wake-up call. It was cold. It was dark. The van would pick us up soon, and we were given food as we were half awake. We were told it would be a perfect day for ballooning, but it…

I opened my eyes. I felt a profound stillness as I gazed out onto the lake and the misty hills behind it. Above a massive cumulonimbus threatened to bring the early monsoon rains. I looked at my…

At the heart of any Grasshopper definition is the data. Grasshopper components process and create data, while wires transport the data between different components. In the last exercise, you may have…