What's wrong with this answer?


  • 1
    T

    10 / 14 test cases passed.

    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 ((DATEDIFF(s2.date, s1.date) = 1 AND DATEDIFF(s3.date, s2.date) = 1)
    OR (DATEDIFF(s2.date, s1.date) = -1 AND DATEDIFF(s3.date, s1.date) = 1)
    OR (DATEDIFF(s2.date, s1.date) = -1 AND DATEDIFF(s3.date, s2.date) = -1)
    )
    ORDER BY s1.date;
    

  • 0
    B

    You only find out a continuous group.


  • 1
    B

    The date may not be continuous.


Log in to reply
 

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