sql - How to count hits greater than X in Access? -


not sure why can't think through; perhaps upcoming weekend!

i have users table:

user | hits mike | 20 jim  | 30 bob  | 9 

and want count number of users have hit count of greater 10. using example table above, output 2 users (mike , jim).

where should start?

select     count([user])     [table]     hits > 10 group     [user] 

Comments