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;

Question

Which of these strategies should you employ to improve the readability of this query?

(1) Capitalize SQL commands.
(2) Use new lines & indentation.
(3) Use snake_case.
(4) Use IN instead of many OR statements.
(5) Use BETWEEN when possible.

Possible answers

(1) and (5).

(1), (3) and (5).

Only (1).

None of these are necessary.

Exercise

Make this query easier to read - Part II

Instructions 1/4

Question

Possible answers