All Posts

Friendly Movies Streamed Last Month Problem

LeetCode 1495. Write an SQL query to report the distinct...

21 Dec 2020

Friend Requests I: Overall Acceptance Rate Problem

LeetCode 597. Write an SQL query to find the overall...

21 Dec 2020

Find The Start And End Number Of Continuous Ranges Problem

LeetCode 1285. Write an SQL query to find the start...

21 Dec 2020

Customers Who Bought Products A And B But Not C Problem

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

21 Dec 2020

Classes More Than 5 Students Problem

LeetCode 596. Please list out all classes which have more...

21 Dec 2020

Capital Gain/Loss Problem

LeetCode 1393. Write an SQL query to report the Capital...

21 Dec 2020

Biggest Single Number Problem

LeetCode 619. Table my_numbers contains many numbers in column num...

21 Dec 2020

Apples & Oranges Problem

LeetCode 1445. Write an SQL query to report the difference...

21 Dec 2020

All People Report To The Given Manager Problem

LeetCode 1270. Write an SQL query to find employee_id of...

21 Dec 2020

Weather Type In Each Country Problem

LeetCode 1294. Write an SQL query to find the type...

20 Dec 2020

User Activity For The Past 30 Days I Problem

LeetCode 1141. Write an SQL query to find the daily...

20 Dec 2020

Triangle Judgement Problem

LeetCode 610. A pupil Tim gets homework to identify whether...

20 Dec 2020

Students And Examinations Problem

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

20 Dec 2020

Sales Person Problem

LeetCode 607. Given three tables, salesperson, company, orders.

20 Dec 2020

Sales Analysis III Problem

LeetCode 1084. Write an SQL query that reports the products...

20 Dec 2020

Sales Analysis II Problem

LeetCode 1083. Write an SQL query that reports the buyers...

20 Dec 2020