统计观看每个类型电影的顾客人数

SELECT movie.movie_type, COUNT(orders.customer_id) AS NumOfCustomers FROM
(orders LEFT JOIN schedule ON orders.schedule_id = schedule.schedule_id)
LEFT JOIN movie ON schedule.movie_id = movie.movie_id
GROUP BY movie.movie_type
ORDER BY NumOfCustomers DESC;