The Paper that can Change the Foundations of all Blockchain Cryptography

Cryptography is at the heart of many blockchain protocols. From traditional proof-of-work(PoW) to L2 modern approaches such as ZK-rollups, many advanced cryptographic methods provide the foundation…


独家优惠奖金 100% 高达 1 BTC + 180 免费旋转

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:

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

Add a comment

Related posts:

Up In A Balloon in Turkey

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…

In Pokhara

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…

Working with Lists

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…