关于#leetcode#的问题：leetcode 1907. 按分类统计薪水的题解 没太明白这个category是有什么作用.求解

Question

SELECT 'High Salary' category,count(1) accounts_count FROM accounts WHERE income>50000
UNION
SELECT 'Average Salary' category,count(1)  accounts_count FROM accounts WHERE income>=20000 AND income<=50000
UNION 
SELECT 'Low Salary' category,count(1) accounts_count FROM accounts WHERE income<20000 

leetcode 1907. 按分类统计薪水的题解 没太明白这个category是有什么作用.求解

Answer 1

这个category就是列名啊，这个是个常量列，值就是前面的字符串。