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