How to select employees under particular salary. For example 6000

Question

https://www.sololearn.com/discuss/375498/?ref=app

Answer 1

SELECT ... WHERE salary <= 6000

If you use grouping with GROUP BY then use HAVING instead of WHERE.

Answer 2

SELECT employee FROM table WHERE salary < 6000;