|
4 | 4 | 1. By questions' category - the folders above |
5 | 5 | 2. By questions' function - the lists below |
6 | 6 |
|
7 | | -## Missing value |
| 7 | +## Missing value or not exist |
8 | 8 | ###### Return and state as "null" |
9 | 9 | [# 1378. Replace Employee ID With The Unique Identi.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Schools%20and%20Organizations/%23%201378.%20Replace%20Employee%20ID%20With%20The%20Unique%20Identi.sql)| - |
10 | 10 | --- | --- |
11 | 11 |
|
12 | 12 | ###### Return and state as 0 |
13 | | - [# 1322. Ads Performance.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) |
8000
| 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) |
14 | 14 | --- | --- |
15 | | -[**# 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) | - |
16 | | - |
17 | | - |
18 | | - |
19 | | -[**# 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) | - |
20 | | - |
| 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) |
21 | 16 |
|
22 | 17 | ###### Return the related column value |
23 | 18 | [# 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-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%20607.%20Sales%20Person.sql) |
24 | 19 | --- | --- |
| 20 | + [**# 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) | [**# 1084. Sales Analysis III.sql**](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%201084.%20Sales%20Analysis%20III.sql) |
25 | 21 |
|
26 | 22 |
|
27 | 23 |
|
|
38 | 34 | ###### As a condition, the result will be compared "more/less than" |
39 | 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) |
40 | 36 | --- | --- |
| 37 | +[**# 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) | - |
41 | 38 |
|
42 | 39 | ###### return categories from numbers |
43 | 40 | [# 1294. Weather Type in Each Country.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Others%20/%23%201294.%20Weather%20Type%20in%20Each%20Country.sql)| - |
|
73 | 70 | [# 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)| [# 1294. Weather Type in Each Country.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Others%20/%23%201294.%20Weather%20Type%20in%20Each%20Country.sql) |
74 | 71 | --- | --- |
75 | 72 |
|
| 73 | +###### Find a specific date/time period |
| 74 | +[# 1113. Reported Posts.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Social%20Media%20and%20Posts/%23%201113.%20Reported%20Posts.sql) | [# 1141. User Activity for the Past 30 Days I.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Social%20Media%20and%20Posts/%23%201141.%20User%20Activity%20for%20the%20Past%2030%20Days%20I.sql) |
| 75 | + --- | --- |
| 76 | + [**# 1084. Sales Analysis III.sql**](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%201084.%20Sales%20Analysis%20III.sql) | - |
| 77 | + |
| 78 | + |
76 | 79 | ###### Modify into a specific format |
77 | 80 | [# 1543. Fix Product Name Format.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%201543.%20Fix%20Product%20Name%20Format.sql) | [# 1565. Unique Orders and Customers Per Month.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%201565.%20Unique%20Orders%20and%20Customers%20Per%20Month.sql) |
78 | 81 | --- | --- |
79 | 82 |
|
80 | 83 | ###### Period of Time |
81 | 84 | [# 1251. Average Selling Price.sql](https://github.com/Qian-Yu-2020/Multiple-Solutions-for-Leetcode-Problems/blob/master/Order%20and%20Deliver/%23%201251.%20Average%20Selling%20Price.sql) | - |
82 | 85 | --- | --- |
| 86 | + |
| 87 | + |
| 88 | + |
83 | 89 |
|
84 | 90 | ###### Case by case |
85 | 91 |
|
|
0 commit comments