Use AS to rename COUNT(*) to users.

Make sure to type AS users.