MFT Info - Friday Doubt

select
Date(c.created_at + interval '8' hour) as Date,
DAY(c.created_at + interval '8' hour) as Day,
hour(c.created_at + interval '8' hour) as startingime,
c.member_id as mid,
m.display_name as name,
count(distinct case when c.kind = 'subscriptionFee' then c.member_id end) as TotalMFTs
from charges c
left join
members m
on c.member_id = m.id
where c.created_at + interval '8' hour >= '2019-3-1 00:00'
group by mid