mysql - 编写查询以了解特定电影类别的租借次数。降序排列

Question

所以我试图回答上述问题，但我无法获得输出，类别名称 | 租用类别的次数。

我的代码如下，

select c.category_id, sum(r.rental_id) as Rental_count
from category c
inner join film_category fc on fc.category_id = c.category_id
inner join film f on f.film_id = fc.film_id
inner join inventory i on i.film_id = f.film_id
inner join rental r on r.inventory_id = i.inventory_id
group by c.category_id, c.name
order by Rental_count desc

标签： mysql

Answer 1

select name as Name, count(rental_id) as Rental_Count
from category 
inner join FILM_CATEGORY
using (category_id)
inner join FILM
using (FILM_ID)
inner join inventory
using (FILM_ID)
inner join Rental 
using (inventory_id)
group by name
order by count(rental_id) desc
limit 1;