All Posts

Activity Participants Problem

LeetCode 1355. Write an SQL query to find the names...

22 Dec 2020

User Activity For The Past 30 Days II Problem

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

21 Dec 2020

The Most Frequently Ordered Products For Each Customer Problem

LeetCode 1596. Write an SQL query to find the most...

21 Dec 2020

Running Total For Different Genders Problem

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

21 Dec 2020

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