All Posts

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

Article Views I Problem

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

19 Dec 2020

Actors And Directors Who Cooperated At Least Three Times Problem

LeetCode 1050. Write a SQL query for a report that...

19 Dec 2020

Unique Orders And Customers Per Month Problem

LeetCode 1565. Write an SQL query to find the number...

18 Dec 2020

Sellers With No Sales Problem

LeetCode 1607. Write an SQL query to report the names...

18 Dec 2020

Rising Temperature Problem

LeetCode 197. Write an SQL query to find all dates’...

18 Dec 2020

Game Play Analysis IV Problem

LeetCode 550. Write an SQL query that reports the fraction...

18 Dec 2020

Game Play Analysis III Problem

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

18 Dec 2020

Game Play Analysis II Problem

LeetCode 512. Write a SQL query that reports the device...

18 Dec 2020

Game Play Analysis I Problem

LeetCode 511. Write an SQL query that reports the first...

18 Dec 2020

Employee Bonus Problem

LeetCode 577. Select all employee’s name and bonus whose bonus...

18 Dec 2020