![[MySQL] SQL 문제](/images/mysql_logo.png){kind=logo}
Table of Contents
SQL
💟 ✅ ❎
문제 리스트
--------------------------------------------- EASY
- Rearrange Products Table 💟 ❎
- Customer Who Visited but Did Not Make Any Transactions 💟 ✅
- Bank Account Summary II 💟 ✅
- Group Sold Products By The Date 💟 ✅
- Immediate Food Delivery I 💟 ✅
- Reformat Department Table 💟 ✅
- Product Sales Analysis I ✅
- Product Sales Analysis II ✅
- The Latest Login in 2020 ✅
- Employees With Missing Information 💟 ✅
- Swap Salary ✅
- Game Play Analysis I ✅
- Primary Department for Each Employee ✅
- Find Customer Referee ✅
- Big Countries ✅
- Customer Placing the Largest Number of Orders ✅
- Customer Order Frequency 💟 ✅
- Combine Two Tables ✅
- Duplicate Emails ✅
- Consecutive Available Seats 💟 ✅
- Employees Earning More Than Their Managers ✅
- Reported Posts 💟 ✅
- Customers Who Never Order ✅
- Fix Product Name Format 💟 ✅
- Delete Duplicate Emails ✅
- User Activity for the Past 30 Days I 💟 ✅
- Sales Analysis II 💟 ✅
- The Number of Employees Which Report to Each Employee 💟 ✅
- Classes More Than 5 Students ✅
- Rising Temperature 💟 ✅
- Friend Requests I: Overall Acceptance Rate 💟 ✅
--------------------------------------------- MEDIUM
- Find the Start and End Number of Continuous Ranges 💟 ❎
- Running Total for Different Genders 💟 ❎
- All People Report to the Given Manager ✅
- Number of Calls Between Two Persons 💟 ✅
- Game Play Analysis III 💟 ✅
- Customers Who Bought Products A and B but Not C 💟 ✅
- Biggest Window Between Visits 💟 ❎
- Evaluate Boolean Expression 💟 ✅
- Tree Node ✅
- Highest Grade For Each Student 💟 ✅
- Number of Accounts That Did Not Stream ✅
- Restaurant Growth 💟 ❎
- Exchange Seats 💟 ✅
- Product Price at a Given Date 💟 ❎
- Customers Who Bought All Products ❎
- Managers with at Least 5 Direct Reports ✅
- Market Analysis I 💟 ✅
- Find Interview Candidates 💟 ❎
- Immediate Food Delivery II 💟 ❎
- Shortest Distance in a Plane ✅
- Rank Scores 💟 ✅
- Movie Rating 💟 ✅
- Countries You Can Safely Invest In 💟 ✅
- League Statistics 💟 ✅
- The Number of Passengers in Each Bus I
- Department Highest Salary
- Consecutive Numbers
- Game Play Analysis IV
- Active Users
- Nth Highest Salary
- Second Degree Follower
- Second Highest Salary
- Reported Posts II
--------------------------------------------- HARD
- Sales by Day of the Week
- Median Employee Salary
- Total Sales Amount by Year
- Average Salary: Departments VS Company
- Longest Winning Streak
- Dynamic Pivoting of a Table
- First and Last Call On the Same Day
- Tournament Winners
- The Number of Passengers in Each Bus II
- Human Traffic of Stadium
- Department Top Three Salaries
- Find Median Given Frequency of Numbers
- The Number of Seniors and Juniors to Join the Company
- Trips and Users