MFTs from Doc Uploaded Rate %

select distinct c.member_id as mid,
date(c.created_at + Interval 8 hour) as date
from charges c
where date(c.created_at + interval 8 hour) >= '2020-02-01'
and c.kind = 'subscriptionFee'