-- 특정 기간 내에 초월 던전을 완료한 횟수
SELECT 
    `user_id`, 
    COUNT(1) AS clearCount
FROM `eod_log`.`table_stage_transcendence`
WHERE (`log_time` BETWEEN '2017-06-20 00:00:00' AND '2017-06-20 23:59:59') AND
      (`is_clear` = 1)
GROUP BY `user_id`;