Show me the name of all the films with release year 2006?
SELECT title FROM film  WHERE release_year = 2006
films with release year 2006 refers to WHERE release_year = 2006; name of all the films refers to SELECT title;