-- Which 5 customers made the most bookings in October 2017

SELECT c.first_name, c.last_name, COUNT(b.id) AS no_bookings FROM bookings b 
JOIN customers c ON c.id = b.customer_id
GROUP BY c.first_name, c.last_name
ORDER BY no_bookings DESC
LIMIT 5;