All Posts

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

Number Of Trusted Contacts Of A Customer Problem

LeetCode 1364. Write an SQL query to find the following...

22 Dec 2020

NPV Queries Problem

LeetCode 1421. Write an SQL query to find the npv...

22 Dec 2020

Last Person To Fit In The Elevator Problem

LeetCode 1204. Write an SQL query to find the person_name...

22 Dec 2020

Highest Grade For Each Student Problem

LeetCode 1112. Write a SQL query to find the highest...

22 Dec 2020

Evaluate Boolean Expression Problem

LeetCode 1440. Write an SQL query to evaluate the boolean...

22 Dec 2020

Calculate Salaries Problem

LeetCode 1468. Write an SQL query to find the salaries...

22 Dec 2020

Activity Participants Problem

LeetCode 1355. Write an SQL query to find the names...

22 Dec 2020

User Activity For The Past 30 Days II Problem

LeetCode 1142. Write an SQL query to find the average...

21 Dec 2020