SQL Study
1.SQL Study 1차시 (SolveSQL, 해커랭크 문제풀이)
1️⃣ 첫 주문과 마지막 주문(Aggregation)Q1. https://solvesql.com/problems/first-and-last-orders/SELECT date(MIN(order_purchase_timestamp)) AS first_order_d
2. SQL Study 2차시 (SolveSQL, Programmers 문제풀이)
중성화 여부 파악하기Q1. https://programmers.co.kr/learn/courses/30/lessons/59409없어진 기록 찾기Q2. https://programmers.co.kr/learn/courses/30/lessons/59042
3.SQL Study 3차시 (SolveSQL, LeetCode 문제풀이)
일별 블로그 방문자 수 집계Q1. https://solvesql.com/problems/blog-counter/일일 매출액 구하기Q2. https://solvesql.com/problems/olist-daily-revenue/성적 순위 구하기Q3. h
4.SQL Study 4차시 (SolveSQL, LeetCode 문제풀이)
지역별 주문의 특징Q1. https://solvesql.com/problems/characteristics-of-orders/할부는 몇 개월로 해드릴까요Q2. https://solvesql.com/problems/installment-month/우유와
5.SQL Study 5차시 (SolveSQL, programmers 문제풀이)
복수 국적 메달 수상한 선수 찾기Q1. https://solvesql.com/problems/multiple-medalist/있었는데요 없었습니다Q2. https://programmers.co.kr/learn/courses/30/lessons/5904
6.SQL Study 6차시 (SolveSQL, Leetcode 문제풀이)
멘토링 짝꿍 리스트Q1. https://solvesql.com/problems/mentor-mentee-list/데이터 그룹으로 묶기Q2. https://solvesql.com/problems/group-by/Exchange SeatsQ3. https