File tree 1 file changed +15
-14
lines changed
1 file changed +15
-14
lines changed Original file line number Diff line number Diff line change @@ -504,19 +504,6 @@ FROM Users
504
504
WHERE mail REGEXP ' ^[A-Za-z][A-Za-z0-9_\.\- ]*@leetcode\\ .com$'
505
505
```
506
506
507
- [ 1907. Count Salary Categories] ( https://leetcode.com/problems/count-salary-categories/ )
508
- ``` sql
509
-
510
- SELECT ' Low Salary' AS category, SUM (IF(income< 20000 ,1 ,0 )) AS accounts_count
511
- FROM Accounts
512
- UNION
513
- SELECT ' Average Salary' AS category, SUM (IF(income>= 20000 AND income<= 50000 ,1 ,0 )) AS accounts_count
514
- FROM Accounts
515
- UNION
516
- SELECT ' High Salary' AS category, SUM (IF(income> 50000 ,1 ,0 )) AS accounts_count
517
- FROM Accounts
518
- ```
519
-
520
507
[ 1204. Last Person to Fit in the Bus] ( https://leetcode.com/problems/last-person-to-fit-in-the-bus/ )
521
508
``` sql
522
509
-- 1000 kg limit
@@ -532,4 +519,18 @@ FROM cte
532
519
WHERE total_weight <= 1000
533
520
ORDER BY total_weight DESC
534
521
LIMIT 1 ;
535
- ```
522
+ ```
523
+
524
+ [ 1907. Count Salary Categories] ( https://leetcode.com/problems/count-salary-categories/ )
525
+ ``` sql
526
+
527
+ SELECT ' Low Salary' AS category, SUM (IF(income< 20000 ,1 ,0 )) AS accounts_count
528
+ FROM Accounts
529
+ UNION
530
+ SELECT ' Average Salary' AS category, SUM (IF(income>= 20000 AND income<= 50000 ,1 ,0 )) AS accounts_count
531
+ FROM Accounts
532
+ UNION
533
+ SELECT ' High Salary' AS category, SUM (IF(income> 50000 ,1 ,0 )) AS accounts_count
534
+ FROM Accounts
535
+ ```
536
+
You can’t perform that action at this time.
0 commit comments