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


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是有什么作用.求解

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