leetcodeSolution to some Leetcode problems written in C++ |
| git clone git://git.dimitrijedobrota.com/leetcode.git |
| Log | Files | Refs | README | LICENSE | |
1907.sql (254B)
1 SELECT "Low Salary" AS category, 2 SUM(income < 20000) AS accounts_count 3 FROM Accounts 4 UNION 5 SELECT "Average Salary", 6 SUM(income >= 20000 AND income <= 50000) 7 FROM Accounts 8 UNION 9 SELECT "High Salary", 10 SUM(income > 50000) 11 FROM Accounts