[solvesql] 일별 블로그 방문자 수 집계 (보통)

SELECT event_date_kst AS dt, COUNT(DISTINCT user_pseudo_id) AS users
FROM ga
WHERE event_date_kst BETWEEN '2021-08-02' AND '2021-08-09'
GROUP BY 1
ORDER BY 1

보통난이도 치곤 너무 무난하다.