How many bookings did each customer make? List the customer id, first name, and the count.
select t1.customer_id, t1.first_name, count(*) from customers as t1 join bookings as t2 on t1.customer_id = t2.customer_id group by t1.customer_id