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.

Take Hint (-7 XP)