SELECT
POSTDATE,
MEMBERS_ALL,
MEMBERS_FROZEN,
SUM(MEMBERS_ALL - MEMBERS_FROZEN) AS MEMBERS_ACTIVE,
MEMBERS_FREE,
SUM(MEMBERS_PPD_SHORTTERM + MEMBERS_PPD_LONGTERM) AS MEMBERS_PPD,
MEMBERS_EFT, MEMBERS_EFT_FAMILY_UNIT,
Convert(EFT_AVG_MEMBER_DUES,decimal(10,2)) AS EFT_AVG_MEMBER_DUES
FROM(
SELECT
daily_numbers.POSTDATE AS POSTDATE,
FORMAT(Max(case when TAG = 'Members_All' then Value end),0) AS MEMBERS_ALL,
FORMAT(Max(case when TAG = 'Members_Frozen' then Value end),0) AS MEMBERS_FROZEN,
FORMAT(Max(case when TAG = 'Members_Ok' then Value end),0) AS MEMBERS_OK,
FORMAT(Max(case when TAG = 'Members_Free' then Value end),0) AS MEMBERS_FREE,
FORMAT(Max(case when TAG = 'Members_PrepaidShortTerm' then Value end),0) AS MEMBERS_PPD_SHORTTERM,
FORMAT(Max(case when TAG = 'Members_PrepaidLongTerm' then Value end),0) AS MEMBERS_PPD_LONGTERM, FORMAT(Max(case when TAG = 'Members_Eft_Family_Unit' then Value end),0) as MEMBERS_EFT_FAMILY_UNIT,
FORMAT(Max(case when TAG = 'Members_Eft' then Value end),0) AS MEMBERS_EFT,
Max(case when TAG = 'EFT_Avg_Member_Dues' then Value end) AS EFT_AVG_MEMBER_DUES
from daily_numbers
group by daily_numbers.POSTDATE) AS daily_sub
WHERE
DATE(POSTDATE) >=  '{STARTDATE}' AND
DATE(POSTDATE) <=  '{ENDDATE}'
GROUP BY POSTDATE 
/* allow-multigym */