경험하고 학습했던 SQL 내용을 정리하고, LeetCode 기반의 SQL 문제를 정리한 저장소 입니다.
이 저장소는 아래와 같은 목적성을 가지고 있습니다.
1. 기초 단계 Base부터 시작하는 지식 저장소.
2. 문제의 경우 풀이를 정리하는 방식을 지향합니다.
GOAL : 하루에 한문제 이상의 문제를 풀고 정리하기
문제 모음집 🔽
- 182. Duplicate Emails
- 511. Game Play Analysis I
- 586. Customer Placing the Largest Number of Orders
- 596. Classes More Than 5 Students
- 619. Biggest Single Number
- 1050. Actors and Directors Who Cooperated At Least Three Times
- 1068. Product Sales Analysis I
- 1084. Sales Analysis III
- 1141. User Activity for the Past 30 Days I
- 1211. Queries Quality and Percentage
- 1484. Group Sold Products By The Date
- 1633. Percentage of Users Attended a Contest
- 1693. Daily Leads and Partners
- 1729. Find Followers Count
- 1741. Find Total Time Spent by Each Employee
- 2356. Number of Unique Subjects Taught by Each Teacher
- 175. Combine Two Tables
- 181. Employees Earning More Than Their Managers
- 183. Customers Who Never Order
- 197. Rising Temperature
- 577. Employee Bonus
- 580. Count Student Number in Departments
- 607. Sales Person
- 1075. Project Employees I
- 1251. Average Selling Price
- 1280. Students and Examinations
- 1327. List the Products Ordered in a Period
- 1378. Replace Employee ID With The Unique Identifier
- 1407. Top Travellers
- 1581. Customer Who Visited but Did Not Make Any Transactions
- 1587. Bank Account Summary II
- 1661. Average Time of Process per Machine
- 1731. The Number of Employees Which Report to Each Employee
- 178. Rank Scores
- 180. Consecutive Numbers
- 184. Department Highest Salary
- 534. Game Play Analysis III
- 626. Exchange Seats
- 1077. Project Employees III
- 1126. Active Businesses
- 1112. Highest Grade For Each Student
- 1308. Running Total for Different Genders
- 1321. Restaurant Growth
- 1341. Movie Rating
- 1445. Apples & Oranges
- + ('Gap & Islands') 1454. Active Users
- 1468. Calculate Salaries
- 1532. The Most Recent Three Orders
- 1549. The Most Recent Orders for Each Product
- 1596. The Most Frequently Ordered Products for Each Customer
- + ('Recursive') 1613. Find the Missing IDs
- 1699. Number of Calls Between Two Persons
- 1709. Biggest Window Between Visits
- 1715. Count Apples and Oranges
- 1831. Maximum Transaction Each Day
- 1867. Orders With Maximum Quantity Above Average
- 1875. Group Employees of the Same Salary
- 1934. Confirmation Rate
- 2066. Account Balance
- 3140. Consecutive Available Seats II
- 578. Get Highest Answer Rate Question
- 1107. New Users Daily Count
- 1045. Customers Who Bought All Products
- 1149. Article Views II
- 1193. Monthly Transactions I
- 1285. Find the Start and End Number of Continuous Ranges
- 1398. Customers Who Bought Products A and B but Not C
- 1811. Find Interview Candidates
- 570. Managers with at Least 5 Direct Reports
- 574. Winning Candidate
- 1132. Reported Posts II
- 1158. Market Analysis I
- 1212. Team Scores in Football Tournament
- 1270. All People Report to the Given Manager
- 1364. Number of Trusted Contacts of a Customer
- 1393. Capital Gain-Loss
- 1501. Countries You Can Safely Invest In
- 1747. Leetflex Banned Accounts
- 1783. Grand Slam Titles
- 3262. Find Overlapping Shifts
- 185. Department Top Three Salaries
- + ('연속성 집계') 225. Report Contiguous Dates
- 569. Median Employee Salary
- 601. Human Traffic of Stadium
- 615. Average Salary: Departments VS Company
- + ('PIVOT') 618. Students Report By Geography
- 1097. Game Play Analysis V
- 1159. Market Analysis II
- + ('RANK 응용') 1194. Tournament Winners
- 1369. Get the Second Most Recent Activity
- + ('재귀') 1384. Total Sales Amount by Year
- 3214. Year on Year Growth Rate