-- How many bookings did the film ‘Jigsaw’ have in October 2017

SELECT COUNT(*) AS no_bookings FROM bookings 
WHERE screening_id IN
(SELECT id FROM screenings 
WHERE film_id = 5);