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