F8-Duration_distribution

use socar_malaysia;
set @startdate = date_sub(CURDATE(), interval 2 month);
set @startdate2 = date_sub(CURDATE(), interval 1 day);

select
distinct r.id as rid,
round(sum(timestampdiff(minute, r.start_at, r.end_at)/60),2) as dur,
count(r.id) as nuse
from reservations r , members m

Where
    r.member_id = m.id
    and m.imaginary in ('sofam', 'normal')
    and r.member_id not in ('125', '127')
    and r.state in ('completed')
    and r.return_at + interval 8 hour >= @startdate
    and r.return_at + interval 8 hour <= @startdate2

group by rid
order by dur desc
;