DLR - Reject Cases

set @start := '2019-6-1';

select
Date(dl.created_at + interval '8' hour) as Date,
dl.member_id,
dlrc.name as reason
from driver_licenses dl
join members m
on m.id = dl.member_id
join driver_license_reject_categories dlrc on dlrc.id = dl.reject_category_id
where dl.created_at + interval '8' hour >= @start
and m.imaginary = 'normal'
and dl.state = 'reject'
group by 1,2