Test 2 - Daily Impact on MFTs - Special Pricing

set @start := '2019-7-1';
select
distinct c.member_id as mid,
date(c.created_at + interval '8' hour) as date
from charges c
join members m on m.id = c.member_id
where c.created_at + interval '8' hour >= @start
and m.imaginary = 'normal'
and c.kind = 'subscriptionFee'
group by 1 ;

set @start1 := '2019-7-22';
set @start2 := '2019-7-23';
select
distinct c.member_id as mid,
date(c.created_at + interval '8' hour) as date
from charges c
join members m on m.id = c.member_id
where c.created_at + interval '8' hour >= @start1
and m.imaginary = 'normal'
and c.kind = 'subscriptionFee'
group by 1