trevorpao
9/16/2013 - 9:49 AM

Select multiple sums

Select multiple sums

multiple_sum.sql
content_copyfile_download
SELECT count(id) AS nums,
    SUM(CASE WHEN currency='Point' THEN amount END) as totalP,
    SUM(CASE WHEN currency='Money' THEN amount END) as totalM
  FROM db_trans WHERE `event_id` in ('2', '4', '3', '9', '7', '10') AND status='Paid'