All Posts

Top Travellers Problem

LeetCode 1407. Write an SQL query to report the distance...

19 Dec 2020

Swap Salary Problem

LeetCode 627. Given a table salary, such as the one...

19 Dec 2020

Shortest Distance Problem

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

19 Dec 2020

Sales Analysis I Problem

LeetCode 1082. Write an SQL query that reports the best...

19 Dec 2020

Reformat Department Table Problem

LeetCode 1179. Write an SQL query to reformat the table...

19 Dec 2020

Product Sales Analysis II Problem

LeetCode 1069. Write an SQL query that reports the total...

19 Dec 2020

Product Sales Analysis I Problem

LeetCode 1068. Write an SQL query that reports all product...

19 Dec 2020

List The Products Ordered In A Period Problem

LeetCode 1327. Write an SQL query to get the names...

19 Dec 2020

Immediate Food Delivery I Problem

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

19 Dec 2020

Find Users With Valid Emails Problem

LeetCode 1517. Write an SQL query to find the users...

19 Dec 2020

Find Customer Referee Problem

LeetCode 584. Given a table customer holding customers information and...

19 Dec 2020

Customer Placing The Largest Number Of Orders Problem

LeetCode 586. Query the customer_number from the orders table for...

19 Dec 2020

Customer Order Frequency Problem

LeetCode 1511. Write an SQL query to report the customer_id...

19 Dec 2020

Create A Session Bar Chart Problem

LeetCode 1435. You want to know how long a user...

19 Dec 2020

Big Countries Problem

LeetCode 595. Write a SQL solution to output big countries’...

19 Dec 2020

Average Selling Price Problem

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

19 Dec 2020