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
Post a Comment