select bikers.first_name, timing.startTime, count(*)
from
bookings
join
bikers_times on bookings.biker_time_id = bikers_times.id
join
timing on bookings.time_id = timing.id
join
bikers on bookings.biker_id = bikers.id
where (bookings.status not in('cancel_admin','cancel_client')
and bookings.booking_type <> 3)
and {{created_at}}
group by bikers.first_name, timing.startTime
order by timing.startTime asc, bikers.first_name asc;
After running this code I want in pivot table visualization all biker names to appear even if the count is null, what should I edit in the code ?