10000 Merge branch 'master' of https://github.com/Qian-Yu-2020/Multiple-Sol… · dana3601/Leetcode-Problems@52a8b8a · GitHub
[go: up one dir, main page]
Skip to content

Commit 52a8b8a

Browse files
Qian-Yu-2020Qian-Yu-2020
committed
2 parents 6ba7d6a + 5f43407 commit 52a8b8a

File tree

1 file changed

+16
-5
lines changed

1 file changed

+16
-5
lines changed

‎README.md

Lines changed: 16 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -10,9 +10,9 @@
1010
--- | ---
1111

1212
###### Return and state as 0
13-
[# 1142. User Activity for the Past 30 Days II.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Customers%20or%20Users/%23%201142.%20User%20Activity%20for%20the%20Past%2030%20Days%20II.sql) | [# 1241. Number of Comments per Post.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Social%20Media%20and%20Posts/%23%201241.%20Number%20of%20Comments%20per%20Post.sql)
13+
[# 1142. User Activity for the Past 30 Days II.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Customers%20or%20Users/%23%201142.%20User%20Activity%20for%20the%20Past%2030%20Days%20II.sql) | [**# 1322. Ads Performance.sql**](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Marketing%20and%20Ecommerce/%23%201322.%20Ads%20Performance.sql)
1414
--- | ---
15-
[**# 1322. Ads Performance.sql**](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Marketing%20and%20Ecommerce/%23%201322.%20Ads%20Performance.sql) | [**# 1407. Top Travellers.sql**](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Customers%20or%20Users/%23%201407.%20Top%20Travellers.sql)
15+
[# 1241. Number of Comments per Post.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Social%20Media%20and%20Posts/%23%201241.%20Number%20of%20Comments%20per%20Post.sql) | [**# 1407. Top Travellers.sql**](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Customers%20or%20Users/%23%201407.%20Top%20Travellers.sql)
1616

1717
###### Return the related column value
1818
[# 1350. Students With Invalid Departments.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Schools%20and%20Organizations/%23%201350.%20Students%20With%20Invalid%20Departments.sql)| [# 607. Sales Person.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leet 10000 code-Problems/blob/master/Order%20and%20Deliver/%23%20607.%20Sales%20Person.sql)
@@ -23,17 +23,23 @@
2323

2424
## Aggregate
2525

26-
###### Most Frequently
27-
[# 1596. The Most Frequently Ordered Products.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%201596.%20The%20Most%20Frequently%20Ordered%20Products.sql)| -
26+
###### Most/Top
27+
[# 1596. The Most Frequently Ordered Products.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%201596.%20The%20Most%20Frequently%20Ordered%20Products.sql)| [# 1082. Sales Analysis I.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%201082.%20Sales%20Analysis%20I.sql)
2828
--- | ---
29+
[**# 1076. Project Employees II.sql**](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Schools%20and%20Organizations/%23%201076.%20Project%20Employees%20II.sql) | -
30+
31+
[**# 619. Biggest Single Number.sql**] | -
2932

3033
###### Return result, and result will be compared "more/less than"
3134
[# 1587. Bank Account Summary II.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Customers%20or%20Users/%23%201587.%20Bank%20Account%20Summary%20II.sql)| -
3235
--- | ---
3336

3437
###### As a condition, the result will be compared "more/less than"
35-
[# 1511. Customer Order Frequency.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%201511.%20Customer%20Order%20Frequency.sql)|[# 1327. List the Products Ordered in a Period.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%201327.%20List%20the%20Products%20Ordered%20in%20a%20Period.sql)
38+
[# 1511. Customer Order Frequency.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%201511.%20Customer%20Order%20Frequency.sql) | [# 1050. Actors and Directors Who Cooperated.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Others%20/%23%201050.%20Actors%20and%20Directors%20Who%20Cooperated.sql)
3639
--- | ---
40+
[**# 1327. List the Products Ordered in a Period.sql**](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%201327.%20List%20the%20Products%20Ordered%20in%20a%20Period.sql) | -
41+
42+
3743
[**# 1083. Sales Analysis II.sql**](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%201083.%20Sales%20Analysis%20II.sql) | -
3844

3945
###### return categories from numbers
@@ -64,6 +70,11 @@
6470
###### across two or more tables
6571
[**# 1571. Warehouse Manager.sql**](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%201571.%20Warehouse%20Manager.sql) | -
6672
--- | ---
73+
74+
###### odd number
75+
[# 620. Not Boring Movies.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Others%20/%23%20620.%20Not%20Boring%20Movies.sql) | -
76+
--- | ---
77+
6778

6879
## Date
6980
###### Find a specific month

0 commit comments

Comments
 (0)
0