leetcode

0 SELECT DISTINCT S1.*

1 FROM Stadium AS S1, Stadium AS S2, Stadium AS S3

2 WHERE S1.people >= 100 AND S2.people >= 100 AND S3.people >= 100

3 AND ((S1.id + 1 = S2.id AND S1.id + 2 = S3.id)

4 OR (S1.id - 1 = S2.id AND S1.id - 2 = S3.id)

5 OR (S1.id - 1 = S2.id AND S1.id + 1 = S3.id))

6 ORDER BY visit_date

7