Main
Hello
Algorithm
Note
Learn
Mark
Tools
AI
Hello
Algorithm
Note
Learn
Mark
Tools
AI

mysql링크

STEP 1. SQL 기초 (10문제)

순서번호문제링크배우는 내용
1175Combine Two Tableshttps://leetcode.cn/problems/combine-two-tables/SELECT, LEFT JOIN
2584Find Customer Refereehttps://leetcode.cn/problems/find-customer-referee/WHERE
3595Big Countrieshttps://leetcode.cn/problems/big-countries/AND, OR
41148Article Views Ihttps://leetcode.cn/problems/article-views-i/DISTINCT
51683Invalid Tweetshttps://leetcode.cn/problems/invalid-tweets/CHAR_LENGTH
61378Replace Employee ID With The Unique Identifierhttps://leetcode.cn/problems/replace-employee-id-with-the-unique-identifier/LEFT JOIN
71068Product Sales Analysis Ihttps://leetcode.cn/problems/product-sales-analysis-i/JOIN
81581Customer Who Visited but Did Not Make Any Transactionshttps://leetcode.cn/problems/customer-who-visited-but-did-not-make-any-transactions/LEFT JOIN + NULL
9197Rising Temperaturehttps://leetcode.cn/problems/rising-temperature/Self Join
10607Sales Personhttps://leetcode.cn/problems/sales-person/NOT EXISTS

STEP 2. 정렬과 조건 (8문제)

순서번호문제링크학습 내용
11511Game Play Analysis Ihttps://leetcode.cn/problems/game-play-analysis-i/MIN
12619Biggest Single Numberhttps://leetcode.cn/problems/biggest-single-number/GROUP BY
132356Number of Unique Subjects Taught by Each Teacherhttps://leetcode.cn/problems/number-of-unique-subjects-taught-by-each-teacher/COUNT DISTINCT
141141User Activity for the Past 30 Days Ihttps://leetcode.cn/problems/user-activity-for-the-past-30-days-i/DATE
151527Patients With a Conditionhttps://leetcode.cn/problems/patients-with-a-condition/LIKE
161873Calculate Special Bonushttps://leetcode.cn/problems/calculate-special-bonus/CASE WHEN
171667Fix Names in a Tablehttps://leetcode.cn/problems/fix-names-in-a-table/UPPER, LOWER
18196Delete Duplicate Emailshttps://leetcode.cn/problems/delete-duplicate-emails/DELETE

STEP 3. GROUP BY & HAVING (10문제)

순서번호문제링크학습 내용
19182Duplicate Emailshttps://leetcode.cn/problems/duplicate-emails/GROUP BY, HAVING
20586Customer Placing the Largest Number of Ordershttps://leetcode.cn/problems/customer-placing-the-largest-number-of-orders/COUNT, GROUP BY
211050Actors and Directors Who Cooperated At Least Three Timeshttps://leetcode.cn/problems/actors-and-directors-who-cooperated-at-least-three-times/GROUP BY, HAVING
221729Find Followers Counthttps://leetcode.cn/problems/find-followers-count/COUNT, GROUP BY
231211Queries Quality and Percentagehttps://leetcode.cn/problems/queries-quality-and-percentage/AVG, ROUND, GROUP BY
241193Monthly Transactions Ihttps://leetcode.cn/problems/monthly-transactions-i/SUM, COUNT, CASE WHEN
251174Immediate Food Delivery IIhttps://leetcode.cn/problems/immediate-food-delivery-ii/MIN, GROUP BY
26550Game Play Analysis IVhttps://leetcode.cn/problems/game-play-analysis-iv/COUNT, JOIN, GROUP BY
271393Capital Gain/Losshttps://leetcode.cn/problems/capital-gain-loss/SUM, CASE WHEN
281398Customers Who Bought Products A and B but Not Chttps://leetcode.cn/problems/customers-who-bought-products-a-and-b-but-not-c/GROUP BY, HAVING

STEP 4. JOIN (15문제)

순서번호문제링크
291070Product Sales Analysis IIIhttps://leetcode.cn/problems/product-sales-analysis-iii/
301075Project Employees Ihttps://leetcode.cn/problems/project-employees-i/
31181Employees Earning More Than Their Managershttps://leetcode.cn/problems/employees-earning-more-than-their-managers/
32626Exchange Seatshttps://leetcode.cn/problems/exchange-seats/
33183Customers Who Never Orderhttps://leetcode.cn/problems/customers-who-never-order/
34184Department Highest Salaryhttps://leetcode.cn/problems/department-highest-salary/
35185Department Top Three Salarieshttps://leetcode.cn/problems/department-top-three-salaries/
36602Friend Requests II: Who Has the Most Friendshttps://leetcode.cn/problems/friend-requests-ii-who-has-the-most-friends/
37608Tree Nodehttps://leetcode.cn/problems/tree-node/
38601Human Traffic of Stadiumhttps://leetcode.cn/problems/human-traffic-of-stadium/
39180Consecutive Numbershttps://leetcode.cn/problems/consecutive-numbers/
40577Employee Bonushttps://leetcode.cn/problems/employee-bonus/
41585Investments in 2016https://leetcode.cn/problems/investments-in-2016/
421132Reported Posts IIhttps://leetcode.cn/problems/reported-posts-ii/
431158Market Analysis Ihttps://leetcode.cn/problems/market-analysis-i/

STEP 5. 서브쿼리 (8문제)

순서번호문제링크
44176Second Highest Salaryhttps://leetcode.cn/problems/second-highest-salary/
45177Nth Highest Salaryhttps://leetcode.cn/problems/nth-highest-salary/
46178Rank Scoreshttps://leetcode.cn/problems/rank-scores/
47262Trips and Usershttps://leetcode.cn/problems/trips-and-users/
481045Customers Who Bought All Productshttps://leetcode.cn/problems/customers-who-bought-all-products/
491164Product Price at a Given Datehttps://leetcode.cn/problems/product-price-at-a-given-date/
501204Last Person to Fit in the Bushttps://leetcode.cn/problems/last-person-to-fit-in-the-bus/
511321Restaurant Growthhttps://leetcode.cn/problems/restaurant-growth/

STEP 6. CASE WHEN (5문제)

순서번호문제링크
521873Calculate Special Bonushttps://leetcode.cn/problems/calculate-special-bonus/
531179Reformat Department Tablehttps://leetcode.cn/problems/reformat-department-table/
541205Monthly Transactions IIhttps://leetcode.cn/problems/monthly-transactions-ii/
551174Immediate Food Delivery IIhttps://leetcode.cn/problems/immediate-food-delivery-ii/
561587Bank Account Summary IIhttps://leetcode.cn/problems/bank-account-summary-ii/

STEP 7. 문자열 / 날짜 함수 (8문제)

순서번호문제링크
571667Fix Names in a Tablehttps://leetcode.cn/problems/fix-names-in-a-table/
581527Patients With a Conditionhttps://leetcode.cn/problems/patients-with-a-condition/
591141User Activity for the Past 30 Days Ihttps://leetcode.cn/problems/user-activity-for-the-past-30-days-i/
601225Report Contiguous Dateshttps://leetcode.cn/problems/report-contiguous-dates/
611454Active Usershttps://leetcode.cn/problems/active-users/
621084Sales Analysis IIIhttps://leetcode.cn/problems/sales-analysis-iii/
631795Rearrange Products Tablehttps://leetcode.cn/problems/rearrange-products-table/
641127User Purchase Platformhttps://leetcode.cn/problems/user-purchase-platform/

STEP 8. Window Function (10문제)

순서번호문제링크
65178Rank Scoreshttps://leetcode.cn/problems/rank-scores/
66185Department Top Three Salarieshttps://leetcode.cn/problems/department-top-three-salaries/
671204Last Person to Fit in the Bushttps://leetcode.cn/problems/last-person-to-fit-in-the-bus/
681321Restaurant Growthhttps://leetcode.cn/problems/restaurant-growth/
691341Movie Ratinghttps://leetcode.cn/problems/movie-rating/
701164Product Price at a Given Datehttps://leetcode.cn/problems/product-price-at-a-given-date/
711934Confirmation Ratehttps://leetcode.cn/problems/confirmation-rate/
721211Queries Quality and Percentagehttps://leetcode.cn/problems/queries-quality-and-percentage/
73601Human Traffic of Stadiumhttps://leetcode.cn/problems/human-traffic-of-stadium/
74180Consecutive Numbershttps://leetcode.cn/problems/consecutive-numbers/

STEP 9. CTE (4문제)

순서번호문제링크
75608Tree Nodehttps://leetcode.cn/problems/tree-node/
761225Report Contiguous Dateshttps://leetcode.cn/problems/report-contiguous-dates/
771070Product Sales Analysis IIIhttps://leetcode.cn/problems/product-sales-analysis-iii/
781321Restaurant Growthhttps://leetcode.cn/problems/restaurant-growth/

STEP 10. 실전 종합 (7문제)

순서번호문제링크
79262Trips and Usershttps://leetcode.cn/problems/trips-and-users/
80601Human Traffic of Stadiumhttps://leetcode.cn/problems/human-traffic-of-stadium/
81184Department Highest Salaryhttps://leetcode.cn/problems/department-highest-salary/
82185Department Top Three Salarieshttps://leetcode.cn/problems/department-top-three-salaries/
831321Restaurant Growthhttps://leetcode.cn/problems/restaurant-growth/
841341Movie Ratinghttps://leetcode.cn/problems/movie-rating/
851934Confirmation Ratehttps://leetcode.cn/problems/confirmation-rate/