[SQL문제풀기] 일별 블로그 방문자 수 집계

문제

solvesql.com

https://solvesql.com/problems/blog-counter/

SQLite

내가 작성한 정답

select event_date_kst dt, count(distinct user_pseudo_id) users
from ga
where event_date_kst between '2021-08-02' and '2021-08-09'
group by event_date_kst
order by 1;