Write SQL query to solve given problem: Among the films that are released in 2006, how many of them are rated Adults Only in the Motion Picture Association Film Rating?. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT COUNT(film_id) FROM film WHERE rating = 'NC-17' AND release_year = 2006