Query for coupon assigned members in Teleport, lalamove, pic

select distinct c.member_id, c.comment , c.coupon_policy_id , m.email , m.display_name ,
if(count(distinct case when dl.state not in ('noInput','null') then dl.member_id end) = 1, "Uploaded","Docs not uploaded") DocUploaded,
if(count(distinct case when dl.state = 'approved' then dl.member_id end),"Approved","Rejected") DocApproved,
Date(c.activated_at + interval 8 hour) as date
from coupons c
left join members m on m.id = c.member_id
left join driver_licenses dl on dl.member_id = m.id
 where c.coupon_policy_id in ('1012','1011','1010','1009','986','994')
 group by 1,2