LeetCode 1907: Count Salary Categories [SQL]

[@andresjvazquez]

Your content is top class !

[@xiamojq621]

Your content is interesting but i wish you had videos on topic including A/B testing since it is your specialty I'm not forcing you it's just a proposal since there is few cotent on the topic

[@frederikmuller]

Thanks for letting me know. I plan to cover some different topics soon but also want to finish up the SQL 50 playlist.
Also, let me know if there’s anything else you’d like to see.

[@cnausp7000]

What do you think of this one?
SELECT
'Low Salary' AS category,
COUNT(*) AS accounts_count
FROM
Accounts
WHERE
income < 20000
UNION ALL
SELECT
'Average Salary' AS category,
COUNT(*) AS accounts_count
FROM
Accounts
WHERE
income BETWEEN 20000 AND 50000
UNION ALL
SELECT
'High Salary' AS category,
COUNT(*) AS accounts_count
FROM
Accounts
WHERE
income > 50000;

[@frederikmuller]

cnausp 😡