DEV Community

Nozibul Islam
Nozibul Islam

Posted on

SQL Leetcode Questions

SQL Leetcode Questions.

  1. Combine Two Tables - 175. Combine Two Tables
  2. Second Highest Salary - 176. Second Highest Salary
  3. Nth Highest Salary - 177. Nth Highest Salary
  4. Rank Scores - 178. Rank Scores
  5. Consecutive Numbers - 180. Consecutive Numbers
  6. Employees Earning More Than Their Managers - 181. Employees Earning More Than Their Managers
  7. Duplicate Emails - 182. Duplicate Emails
  8. Customers Who Never Order - 183. Customers Who Never Order
  9. Delete Duplicate Emails - 196. Delete Duplicate Emails
  10. Rising Temperature - 197. Rising Temperature
  11. Game Play Analysis I - 511. Game Play Analysis I
  12. Game Play Analysis II - 512. Game Play Analysis II
  13. Game Play Analysis III - 534. Game Play Analysis III
  14. Managers with at Least 5 Direct Reports - 570. Managers with at Least 5 Direct Reports
  15. Employee Bonus - 577. Employee Bonus
  16. Find Customer Referee - 584. Find Customer Referee
  17. Customer Placing the Largest Number of Orders - 586. Customer Placing the Largest Number of Orders
  18. Big Countries - 595. Big Countries
  19. Classes with More Than 5 Students - 596. Classes More Than 5 Students
  20. Friend Requests I: Overall Acceptance Rate - 597. Friend Requests I: Overall Acceptance Rate
  21. Consecutive Available Seats - 603. Consecutive Available Seats
  22. Sales Person - 607. Sales Person
  23. Tree Node - 608. Tree Node
  24. Triangle Judgement - 610. Triangle Judgement
  25. Shortest Distance in a Plane - 612. Shortest Distance in a Plane
  26. Shortest Distance in a Line - 613. Shortest Distance in a Line
  27. Biggest Single Number - 619. Biggest Single Number
  28. Not Boring Movies - 620. Not Boring Movies
  29. Exchange Seats - 626. Exchange Seats
  30. Swap Salary - 627. Swap Salary
  31. Customers Who Bought All Products - 1045. Customers Who Bought All Products
  32. Actors and Directors Who Cooperated At Least Three Times - 1050. Actors and Directors Who Cooperated At Least Three Times
  33. Product Sales Analysis I - 1068. Product Sales Analysis I
  34. Product Sales Analysis II - 1069. Product Sales Analysis II
  35. Product Sales Analysis III - 1070. Product Sales Analysis III
  36. Project Employees I - 1075. Project Employees I
  37. Project Employees II - 1076. Project Employees II
  38. Project Employees III - 1077. Project Employees III
  39. Sales Analysis I - 1082. Sales Analysis I
  40. Sales Analysis II - 1083. Sales Analysis II
  41. Sales Analysis III - 1084. Sales Analysis III
  42. Highest Grade for Each Student - 1112. Highest Grade For Each Student
  43. Reported Posts - 1113. Reported Posts
  44. Active Businesses - 1126. Active Businesses
  45. User Activity for the Past 30 Days I - 1141. User Activity for the Past 30 Days I
  46. User Activity for the Past 30 Days II - 1142. User Activity for the Past 30 Days II
  47. Article Views I - 1148. Article Views I
  48. Product Price at a Given Date - 1164. Product Price at a Given Date
  49. Immediate Food Delivery I - 1173. Immediate Food Delivery I
  50. Immediate Food Delivery II - 1174. Immediate Food Delivery II
  51. Reformat Department Table - 1179. Reformat Department Table
  52. Monthly Transactions I - 1193. Monthly Transactions I
  53. Last Person to Fit in the Elevator - 1204. Last Person to Fit in the Elevator
  54. Queries Quality and Percentage - 1211. Queries Quality and Percentage
  55. Team Scores in Football Tournament - 1212. Team Scores in Football Tournament
  56. Report Contiguous Dates - 1225. Report Contiguous Dates
  57. Number of Comments per Post - 1241. Number of Comments per Post
  58. Average Selling Price - 1251. Average Selling Price
  59. Page Recommendations - 1264. Page Recommendations
  60. All People Report to the Given Manager - 1270. All People Report to the Given Manager
  61. Students and Examinations - 1280. Students and Examinations
  62. Find the Start and End Number of Continuous Ranges - 1285. Find the Start and End Number of Continuous Ranges
  63. Weather Type in Each Country - 1294. Weather Type in Each Country
  64. Find the Team Size - 1303. Find the Team Size
  65. Running Total for Different Genders - 1308. Running Total for Different Genders
  66. Restaurant Growth - 1321. Restaurant Growth
  67. Ads Performance - 1322. Ads Performance
  68. List the Products Ordered in a Period - 1327. List the Products Ordered in a Period
  69. Number of Transactions per Visit - 1336. Number of Transactions per Visit

🔗 Connect with me on LinkedIn:

Let’s dive deeper into the world of software engineering together! I regularly share insights on JavaScript, TypeScript, Node.js, React, Next.js, data structures, algorithms, web development, and much more. Whether you're looking to enhance your skills or collaborate on exciting topics, I’d love to connect and grow with you.

Follow me: Nozibul Islam

Top comments (2)

Collapse
 
wings_recruitment_481c9cc profile image
Wings Recruitment

Informative

Collapse
 
nozibul_islam_113b1d5334f profile image
Nozibul Islam

tnx.