让这个查询更易读 - 第 II 部分
在本练习中，您将改写下面的查询，使其更易于阅读。
select
category as FILMCATEGORY,
avg(length) as AverageLength
from film as f
inner join category as c
on f.film_id = c.film_id
where release_year >= 2005
and release_year <= 2010
group by category;
本练习是课程的一部分
将 SQL 应用于真实问题
交互式实操练习
通过完成这段示例代码来试试这个练习。
select
category as FILMCATEGORY,
avg(length) as AverageLength
from film as f
inner join category as c
on f.film_id = c.film_id
where release_year >= 2005
and release_year <= 2010
group by category;