All Posts

Monthly Transactions II Problem

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

26 Dec 2020

Get Highest Answer Rate Question Problem

LeetCode 578. Write a sql query to identify the question...

26 Dec 2020

Department Highest Salary Problem

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

26 Dec 2020

Article Views II Problem

LeetCode 1149. Write an SQL query to find all the...

26 Dec 2020

Active Users Problem

LeetCode 1454. Write an SQL query to find the id...

26 Dec 2020

Winning Candidate Problem

LeetCode 574. Write a sql to find the name of...

25 Dec 2020

Team Scores In Football Tournament Problem

LeetCode 1212. Write an SQL query that selects the team_id,...

25 Dec 2020

Rank Scores Problem

LeetCode 178. Write a SQL query to rank scores. If...

25 Dec 2020

Product Sales Analysis III Problem

LeetCode 1070. Write an SQL query that selects the product...

25 Dec 2020

Movie Rating Problem

LeetCode 1341. Write the following SQL query to find the...

25 Dec 2020

Investments In 2016 Problem

LeetCode 585. Write a query to print the sum of...

25 Dec 2020

Immediate Food Delivery II Problem

LeetCode 1174. Write an SQL query to find the percentage...

25 Dec 2020

Friend Requests II: Who Has The Most Friends Problem

LeetCode 602. In social network like Facebook or Twitter, people...

25 Dec 2020

Countries You Can Safely Invest In Problem

LeetCode 1501. Write an SQL query to find the countries...

25 Dec 2020

Count Student Number In Departments Problem

LeetCode 580. A university uses 2 data tables, student and...

25 Dec 2020

Bank Account Summary Problem

LeetCode 1555. Our bank records all transactions in the table...

25 Dec 2020