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 😡