RE:cord

[SQL] Daily Active Users 본문

SQL

[SQL] Daily Active Users

beie 2024. 12. 17. 15:58 

SELECT account_id, AVG(average_daily_count)
FROM (SELECT account_id, count(*) average_daily_count
        FROM sf_events
        WHERE date BETWEEN '2021-01-01' AND '2021-01-31'
        --or.. WHERE date LIKE '2021-01%'
        GROUP BY account_id) counting
GROUP BY account_id

'SQL' 카테고리의 다른 글

[SQL] Walmart's Same-Day Orders  (0) 2024.12.31
[SQL] Matching Grades and Ordering (등급 부여하고 정렬하기)  (1) 2024.12.19
[SQL] GROUP BY vs PARTITION BY  (0) 2024.12.16
[SQL] Why UNION?  (4) 2024.12.14
[SQL] Finding Unsold Products (한 번도 팔리지 않은 제품 찾기) (IS NULL / NOT EXIST)  (0) 2024.12.14
'SQL' Related Articles more