SQL

SQL 스터디

1주차 (09.02.월 ~ )

• 기본 SELECT문 사용 문제

1. Recyclable and Low Fat Products (EASY)
   https://leetcode.com/problems/recyclable-and-low-fat-products/?envType=study-plan-v2&envId=top-sql-50
2. Find Customer Referee (EASY)
   https://leetcode.com/problems/find-customer-referee/?envType=study-plan-v2&envId=top-sql-50
3. Big Countries (EASY)
   https://leetcode.com/problems/big-countries/?envType=study-plan-v2&envId=top-sql-50

• Grouping

4. 연간 평가점수에 해당하는 평가 등급 및 성과금 조회하기 (프그 LV04)
   https://school.programmers.co.kr/learn/courses/30/lessons/284528
5. 대여 기록이 존재하는 자동차 리스트 구하기 (프그 LV03)
   https://school.programmers.co.kr/learn/courses/30/lessons/157341

---

2주차 (09.09.월 ~ )

• join문제

1. Rising Temperature (EASY)
   https://leetcode.com/problems/rising-temperature/description/?envType=study-plan-v2&envId=top-sql-50
2. 5월 식품들의 총매출 조회하기 (프그 LV04)
   https://school.programmers.co.kr/learn/courses/30/lessons/131117
3. Managers with at Least 5 Direct Reports (MEDIUM)
   https://leetcode.com/problems/managers-with-at-least-5-direct-reports/description/?envType=study-plan-v2&envId=top-sql-50
4. 특정 기간동안 대여 가능한 자동차들의 대여비용 구하기 (프그 LV04)
   https://school.programmers.co.kr/learn/courses/30/lessons/157339

• 집계함수

5. Not Boring Movies (EASY)
   https://leetcode.com/problems/not-boring-movies/description/?envType=study-plan-v2&envId=top-sql-50

---

3주차 (09.16.월 ~ )

• 집계함수

1. Percentage of Users Attended a Contest (EASY)
   https://leetcode.com/problems/percentage-of-users-attended-a-contest/description/?envType=study-plan-v2&envId=top-sql-50
2. Game Play Analysis IV (MEDIUM)
   https://leetcode.com/problems/game-play-analysis-iv/description/?envType=study-plan-v2&envId=top-sql-50

• Sorting and Grouping

3. Number of Unique Subjects Taught by Each Teacher (EASY)
   https://leetcode.com/problems/number-of-unique-subjects-taught-by-each-teacher/description/?envType=study-plan-v2&envId=top-sql-50
4. Product Sales Analysis III (MEDIUM)
   https://leetcode.com/problems/product-sales-analysis-iii/description/?envType=study-plan-v2&envId=top-sql-50

• Join

5. Department Top Three Salaries (HARD)
   https://leetcode.com/problems/department-top-three-salaries/description/