MySQL command!

Question

You have a table with employee payment, you have to select employee with less payment than average.
I tried the following command:

SELECT username FROM users WHERE payment < AVG(payment)

ERROR
#1111 - invalid use of group function

Answer 1

SELECT username FROM users WHERE payment < (SELECT AVG (payment) FROM users) ?

Answer 2

Not to my knowledge.

Answer 3

Well, just found the answer. That would be
SELECT username FROM users WHERE payment<(SELECT AVG(payment) FROM users)

**IF anyone knows a better /easier way let me know.

Answer 4

Yah, I found it too. Any easier command?

Answer 5

SELECT username FROM users WHERE payment<(SELECT AVG(payment) FROM users)

**This is the simplest command you can find out there unless you want to group the observations and then use the HAVING clause.