Topic
SQL problems
80 problems: 50 easy, 23 medium, 7 hard.
Easy (50)
- Select All Employees
- Employees With High Salary
- Count Employees Per Department
- Average Salary By Department
- Find Duplicate Emails
- Customers Without Orders
- Rising Temperature
- Delete Duplicate Emails
- Employees and Bonus
- Product Sales Analysis
- Top Travellers
- Group Sold Products
- User Activity Count
- Queries Quality and Percentage
- Ads Performance
- Find Team Size
- Big Countries
- Article Views I
- Invalid Tweets
- Calculate Special Bonus
- Fix Names in a Table
- Patients With a Condition
- Employees in Unique Department
- Daily Leads and Partners
- Actors and Directors
- Sales Person
- Triangle Judgement
- Biggest Single Number
- Swap Salary
- Find Customer Referee
- Order By Two Columns
- Not Boring Movies
- Classes More Than 5 Students
- Combine Two Tables
- Employees Earning More Than Managers
- Game Play Analysis
- Select Name and Salary
- Products In Price Range
- Distinct Departments
- Total Quantity Sold
- Engineering High Earners
- Products In Categories
- Names Starting With A
- Top 3 Earners
- Count Distinct Customers
- Lowest and Highest Salary
- Contacts With Email
- Even-Id Items
- Line Item Total
- Uppercase Names
Medium (23)
- Second Highest Salary
- Department Highest Salary
- Consecutive Numbers
- Nth Highest Salary
- Rank Scores
- Managers With 5+ Reports
- Winning Candidate
- Reformat Department Table
- Monthly Transactions
- Immediate Food Delivery
- Cumulative Sum of Sales
- Find Gaps in Sequence
- Revenue By Product
- Students With Classes
- Repeat Customers
- Average Salary By Department
- Customers Without Orders
- Distinct Products Sold Per Day
- Salary Bands
- Default Bonus
- Orders and Revenue Per Product
- Region Revenue Share
- Top Spending Customer