Write SQL query to solve given problem: How many films have a rental duration of over 6 days?. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT COUNT(film_id) FROM film WHERE rental_duration > 6