Among the films that are released in 2006, how many of them are rated Adults Only in the Motion Picture Association Film Rating?
released in 2006 refers to release_year = 2006; rated Adults Only refers to rating = 'NC-17'
SELECT COUNT(film_id) FROM film WHERE rating = 'NC-17' AND release_year = 2006