讓這個查詢更好讀－第二部分
在這個練習中，你要把下面的查詢改寫得更容易閱讀。
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;