매일 출석체크 하는 사람 조회 MYSQL

SELECT uid FROM attend WHERE dt BETWEEN '2017-11-01' AND '2017-11-10' GROUP BY uid HAVING COUNT(*) = DATEDIFF('2017-11-10', '2017-11-01') + 1 ; 출처 : www.gurubee.net/article/78513