1

SELECT externalsource,
SUM(CASE WHEN TRUNC(bettime) BETWEEN TRUNC(ADD_MONTHS(current_date, - 3))
AND TRUNC(current_date) THEN betamount_defcur ELSE 0 END) AS betamount_defcur_month3,
SUM(CASE WHEN TRUNC(calctime) BETWEEN TRUNC(ADD_MONTHS(current_date, - 3))
AND TRUNC(current_date) THEN winamount_defcur ELSE 0 END) AS winamount_defcur_month3,
SUM(CASE WHEN TRUNC(bettime) BETWEEN TRUNC(ADD_MONTHS(current_date, - 3))
AND TRUNC(current_date) THEN 1 ELSE 0 END) AS month3_bets,
SUM(CASE WHEN TRUNC(bettime) BETWEEN TRUNC(ADD_MONTHS(current_date, - 6))
AND TRUNC(current_date) THEN betamount_defcur ELSE 0 END) AS betamount_defcur_month6,
SUM(CASE WHEN TRUNC(calctime) BETWEEN TRUNC(ADD_MONTHS(current_date, - 6))
AND TRUNC(current_date) THEN winamount_defcur ELSE 0 END) AS winamount_defcur_month6,
SUM(CASE WHEN TRUNC(bettime) BETWEEN TRUNC(ADD_MONTHS(current_date, - 6))
AND TRUNC(current_date) THEN 1 ELSE 0 END) AS month6_bets,
SUM(CASE WHEN TRUNC(bettime) BETWEEN TRUNC(ADD_MONTHS(current_date, - 12))
AND TRUNC(current_date) THEN betamount_defcur ELSE 0 END) AS winamount_defcur_month12,
SUM(CASE WHEN TRUNC(calctime) BETWEEN TRUNC(ADD_MONTHS(current_date, - 12))
AND TRUNC(current_date) THEN winamount_defcur ELSE 0 END) AS betamount_defcur_month12,
SUM(CASE WHEN TRUNC(bettime) BETWEEN TRUNC(ADD_MONTHS(current_date, - 12))
AND TRUNC(current_date) THEN 1 ELSE 0 END) AS month12_bets,
SUM(betamount_defcur) AS betamount_defcur,SUM(winamount_defcur) AS winamount_defcur, COUNT(*) AS bets
FROM externalbet WHERE  punterid=2703275
GROUP BY externalsource;