• Home
• com.github.javadev
• leetcode-in-java
• 1.10
• source code
• script.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

g0601_0700.s0601_human_traffic_of_stadium.script.sql Maven / Gradle / Ivy

# Write your MySQL query statement below
# #Hard #Database #2022_03_21_Time_328_ms_(62.41%)_Space_0B_(100.00%)
select id, visit_date, people
from 
(select 

id, visit_date, people, 
 lead(people, 1) over ( order by id) as 1_next, 
 lead(people, 2) over ( order by id) as 2_next,
 lag(people, 1) over ( order by id) as 1_prev,
 lag(people, 2) over ( order by id) as 2_prev

from Stadium
) a

where (people >= 100) and

(
    (1_next >= 100 and 2_next >=100) or
    (1_prev >= 100 and 2_prev >=100) or
    (1_prev >= 100 and 1_next >=100)
)