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)


      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