SELECT distinct s1.id, s1.date, s1.people from stadium s1, stadium s2, stadium s3
where s1.people >= 100 and s2.people >= 100 and s3.people >= 100
and ((s2.id = s1.id + 1 and s3.id = s2.id +1) or (s2.id =s1.id-1 and s3.id = s2.id -1) or (s1.id = s2.id + 1 and s3.id = s1.id +1))
order by s1.id'''
Is there a better solution?
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.