解决思路:
代码实现:
SELECT a.*
FROM Leetcode_stadium a,
(SELECT id - rownum AS TYPE,
group_concat(id) idlist
FROM
(SELECT @rn := @rn+1 AS rownum, t.id,
t.date,
t.people
FROM Leetcode_stadium t
WHERE people >= 100)t
GROUP BY id- rownum HAVING length(idlist) > 3) b
WHERE find_in_set(a.id,b.idlist);