Write SQL query to solve given problem: How many films have a duration between 100 to 110 minutes?. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT COUNT(film_id) FROM film WHERE length BETWEEN 100 AND 110