Number of Bookings Each Day

SELECT
distinct r.id,
sum(p.amount) as amount,
date(r.occupy_start_at + interval '8' hour) as days,
count(r.state) as bookings
from payments p
join
reservations r
on p.member_id = r.member_id
where r.occupy_start_at + interval '8' hour >= '2019-2-1 00:00'
and r.occupy_start_at + interval '8' hour <= '2019-2-28 00:00'
and r.state = "completed"

group by 1