many SubQuery, time costs 0.00018575ms


  • 0
    Z

    select t.id3 as id, t.date, t.people from (
    select s.id-2 id1, s.id-1 id2, s.id id3, s.id+1 id4, s.id+2 id5, date, people
    from stadium s
    where people > 99
    ) t
    where (t.id1 in (select id
    from stadium s
    where people > 99) and t.id2 in (select id
    from stadium s
    where people > 99)) or( t.id4 in (select id
    from stadium s
    where people > 99) and t.id5 in (select id
    from stadium s
    where people > 99)) or( t.id2 in (select id
    from stadium s
    where people > 99) and t.id4 in (select id
    from stadium s
    where people > 99))


Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.