SQL:

Select the film title and release year of all films in the English language.

Select the film title and release year of all films in the French language.

Show both queries.

You must join with language.name to identify the language. You cannot embed language id value into your query.

Expected English Result Set Size: 1000 Rows

Expected French Result Set Size: 0 Rows