주간 SQL Study 4차시 (Group by, Select, Join 문제풀이)

1️⃣ 지역별 주문의 특징 Q1. https://solvesql.com/problems/characteristics-of-orders/ solvesql © Copyright 2021-2022 solvesql.com solvesql.com select Region , sum(case when category = 'Furniture' then orders end) as Furniture , sum(case when category = 'Office Supplies' then orders end) as 'Office Supplies' , sum(case when category = 'Technology' then orders end) as Technology FROM (select region AS 'Regi..
Data Analystics/SQL 2022. 3. 13. 00:02
주간 SQL Study 3차시 (SolveSQL, LeetCode 문제풀이)

1️⃣ 일별 블로그 방문자 수 집계 Q1. https://solvesql.com/problems/blog-counter/ solvesql © Copyright 2021-2022 solvesql.com solvesql.com 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 event_date_kst -- HAVING event_date_kst>='2021-08-02' AND event_date_kst ='2021-08-02' AND event_date_kst
Data Analystics/SQL 2022. 3. 9. 23:21
1