oef 3

SELECT m.movieName AS 'Naam film', showDatesStart AS 'Eerste vertoning',
CASE
    WHEN COUNT(bookedSeatID) >= 200 THEN 'Kaskraker'
    WHEN COUNT(bookedSeatID) < 500 THEN 'Geflopt'
    ELSE 'Normaal'
END AS 'Succesrating'
FROM BookedSeat bs
JOIN Booking b ON bs.bookingID = b.bookingID
JOIN Movie m ON b.movieID = m.movieID
JOIN MovieShowing ms ON m.movieID = ms.movieID
WHERE COUNT(bookedSeatID) > 0 AND ms.movieID NOT NULL
ORDER BY m.movieName ASC;