与我的sql语句的工作方式有些混淆。我正在尝试从日期范围中选择一个名为``投票''的数据“每月最高投票”,“每周最高投票”等。 这就是问题所在。我的SQL语句:

FROM studentid.questions 
WHERE vote IN (
                SELECT MAX(vote) 
                FROM studentid.questions 
                WHERE YEAR(timestamp) = 2020 
                AND WEEK(timestamp, 4) = 21

In my case, the top vote of the week (05/21/2020) should be 2 votes which is correct, but it displays data from january and february that has 2 votes as well. Check the picture link below to see the results..which simply does not match. enter image description here