Make this query easier to read - Part II
In this exercise you will work on making the query below easier to read.
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;
Deze oefening maakt deel uit van de cursus
Applying SQL to Real-World Problems
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
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;