All Posts

Tree Node Problem

LeetCode 608. Given a table tree, id is identifier of...

23 Dec 2020

The Most Recent Orders For Each Product Problem

LeetCode 1549. Write an SQL query to find the most...

23 Dec 2020

Shortest Distance In A Plane Problem

LeetCode 612. Write a query to find the shortest distance...

23 Dec 2020

Rectangles Area Problem

LeetCode 1459. Write an SQL query to report of all...

23 Dec 2020

Product Price At A Given Date Problem

LeetCode 1164. Write an SQL query to find the prices...

23 Dec 2020

Page Recommendations Problem

LeetCode 1264. Write an SQL query to recommend pages to...

23 Dec 2020

Monthly Transactions I Problem

LeetCode 1193. Write an SQL query to find for each...

23 Dec 2020

Market Analysis I Problem

LeetCode 1158. Write an SQL query to find for each...

23 Dec 2020

Managers With At Least 5 Direct Reports Problem

LeetCode 570. Given the Employee table, write a SQL query...

23 Dec 2020

Find The Missing IDs Problem

LeetCode 1613. Write an SQL query to find the missing...

23 Dec 2020

Exchange Seats Problem

LeetCode 626. Mary is a teacher in a middle school...

23 Dec 2020

Customers Who Bought All Products Problem

LeetCode 1045. Write an SQL query for a report that...

23 Dec 2020

Active Business Problem

LeetCode 1126. Write an SQL query to find all active...

23 Dec 2020

The Most Recent Three Orders Problem

LeetCode 1532. Write an SQL query to find the most...

22 Dec 2020

Restaurant Growth Problem

LeetCode 1321. You are the restaurant owner and you want...

22 Dec 2020

Project Employees III Problem

LeetCode 1077. Write an SQL query that reports the most...

22 Dec 2020