All Posts

Tournament Winners Problem

LeetCode 1194. Write an SQL query to find the winner...

28 Dec 2020

Students Report By Geography Problem

LeetCode 618. A U.S graduate school has students from Asia,...

28 Dec 2020

Report Contiguous Dates Problem

LeetCode 1225. Write an SQL query to generate a report...

28 Dec 2020

Median Employee Salary Problem

LeetCode 569. Write a SQL query to find the median...

28 Dec 2020

Market Analysis II Problem

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

28 Dec 2020

Hopper Company Queries I Problem

LeetCode 1635. Write an SQL query to report the following...

28 Dec 2020

Game Play Analysis V Problem

LeetCode 1097. Write an SQL query that reports for each...

28 Dec 2020

User Purchase Platform Problem

LeetCode 1127. Write an SQL query to find the total...

27 Dec 2020

Trips And Users Problem

LeetCode 262. Write a SQL query to find the cancellation...

27 Dec 2020

Number Of Transactions Per Visit Problem

LeetCode 1336. Write an SQL query to find how many...

27 Dec 2020

Human Traffic Of Stadium Problem

LeetCode 601. Write an SQL query to display the records...

27 Dec 2020

Hopper Company Queries II Problem

LeetCode 1645. Write an SQL query to report the percentage...

27 Dec 2020

Find Median Given Frequency Of Numbers Problem

LeetCode 571. Write a query to find the median of...

27 Dec 2020

Find Cumulative Salary Of An Employee Problem

LeetCode 579. Write a SQL to get the cumulative sum...

27 Dec 2020

Department Top Three Salaries Problem

LeetCode 185. Write a SQL query to find employees who...

27 Dec 2020

Average Salary: Departments VS Company Problem

LeetCode 615. Given two tables as below, write a query...

27 Dec 2020