leetcode

Solution 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