70 practice problems
LeetCode Curated SQL 70
LeetCode
In the early days, SQL, as a language for querying databases, was an essential skill for programmers,
because only after obtaining the correct data set, subsequent data processing and analysis can happen.
During an interview, SQL is also a key factor. Through these 70 practice problems, you will build a solid 'database' foundation.
- Game Play Analysis I
- Game Play Analysis II
- Game Play Analysis III
- Game Play Analysis IV
- Managers with at Least 5 Direct Reports
- Find Median Given Frequency of Numbers
- Count Student Number in Departments
- Customer Placing the Largest Number of Orders
- Consecutive Available Seats
- Sales Person
- Tree Node
- Triangle Judgement
- Shortest Distance in a Line
- Average Salary: Departments VS Company
- Customers Who Bought All Products
- Actors and Directors Who Cooperated At Least Three Times
- Product Sales Analysis I
- Project Employees I
- Project Employees II
- Project Employees III
- Sales Analysis I
- Sales Analysis II
- Sales Analysis III
- Game Play Analysis V
- Unpopular Books
- Highest Grade For Each Student
- Reported Posts
- Active Businesses
- Reported Posts II
- User Activity for the Past 30 Days I
- Article Views I
- Article Views II
- Product Price at a Given Date
- Immediate Food Delivery I
- Monthly Transactions I
- Tournament Winners
- Last Person to Fit in the Bus
- Monthly Transactions II
- Team Scores in Football Tournament
- Report Contiguous Dates
- Average Selling Price
- Page Recommendations
- All People Report to the Given Manager
- Students and Examinations
- Find the Start and End Number of Continuous Ranges
- Weather Type in Each Country
- Find the Team Size
- Running Total for Different Genders
- Restaurant Growth
- Ads Performance
- List the Products Ordered in a Period
- Number of Transactions per Visit
- Movie Rating
- Students With Invalid Departments
- Get the Second Most Recent Activity
- Replace Employee ID With The Unique Identifier
- Total Sales Amount by Year
- Capital Gain/Loss
- Top Travellers
- Find the Quiet Students in All Exams
- NPV Queries
- Evaluate Boolean Expression
- Apples & Oranges
- Calculate Salaries
- Group Sold Products By The Date
- Friendly Movies Streamed Last Month
- Countries You Can Safely Invest In
- Customer Order Frequency
- Find Users With Valid E-Mails
- The Most Recent Three Orders