SQL syntax to count the number of rows where the sum of a column is equal or greater than a value

Hi,

I have a table that records points that users are awarded. A user can have multiple rows in a table as points are awarded at different times. I am trying to write a SQL statement that will count the number of users that have total points greater or equal to 12 points. For example:

User       Points      Date
John        2             2013-12-01
Adam      4             2013-12-02
Mike       6             2013-12-02
John              6             2013-12-04
Mike              8             2013-12-05
John          6             2013-12-06
 
So in this example the count would be 2 (John and Mike).

Any help would be greatly appreciated. Thank you
bootneck2222Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Louis01Connect With a Mentor Commented:
select count(*) 
  from (select [User], SUM(points) as sum_points
          from @myTable
         group by [User]
        having SUM(Points) > 12) t1

Open in new window

0
 
ArgentiCommented:
select user, sum(points)
from mytable t
group by user
having sum(points) >= 12

Open in new window

0
 
bootneck2222Author Commented:
Thank you Louis01.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.