Re: QUERY HELP

[Peter Brawley]

This query ...

select user_id,sum(amount) total
from table
group by user_id;

... gets you sums grouped by user_id, so this query ...

select user_id
from (
  select user_id,sum(amount) as total
  from table
  group by user_id
) x
where x,total=5000;

... gets you user_ids with sums equal to 5000.