Shiva query for push notifcations

set @monthInterval = 1;

select
members.id,
YEAR(curdate()) - YEAR(members.birthday) as age,
( select ifnull(count(reservations.id),0)
from reservations where reservations.member_id = members.id and reservations.state = 'completed'
) as srid
from members
left join driver_licenses
on driver_licenses.member_id = members.id
where members.state = 'normal'
and driver_licenses.state = 'approved'
and convert_tz(members.created_at, '+00:00', '+8:00') > date_add(now(), interval -@monthInterval month)
group by members.id