mySQL Query Help

[dannystommen]

It will look something like the following. Also, you are using COUNT, you should use SUM if you want the total amount of money

SELECT 
  name,
  CASE WHEN SUM(money) > 5 
    THEN 'lots of money'
    ELSE 'running low'
  END
FROM 
  mytable
GROUP BY 
  member_id;