Leetcode数据库题解-601. Human Traffic of Stadium

题目地址：https://leetcode.com/problems/human-traffic-of-stadium/

题解：如下代码

select distinct t1.*
from stadium t1, stadium t2, stadium t3
where t1.people>99 and t2.people>99 and t3.people>99
      and (
          (t1.id+1=t2.id and t2.id+1=t3.id)
           or (t1.id-1=t2.id and t1.id+1=t3.id)
           or (t2.id+1=t3.id and t3.id+1=t1.id)
          )
order by t1.id;