Growing Business Analyst

1️⃣ 멘토링 짝꿍 리스트 Q1. https://solvesql.com/problems/mentor-mentee-list/ solvesql © Copyright 2021-2022 solvesql.com solvesql.com select e1.employee_id as mentee_id, e1.name as mentee_name, e2.employee_id as mentor_id, e2.name as mentor_name from employees e1, employees e2 where e1.join_date between '2021-09-01' and '2021-12-31' and e2.join_date

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