Linking the film and language tables based language language french here

Films in English & French- Embeddable languages Answers (Assignment)

Your question:

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

-- Query to select films in English language

SELECT film.title, film.release_year

• SELECT film.title, film.release_year: This part of the query specifies the columns we want to retrieve from the database, which are the film title and release year.

• FROM film: We start by selecting data from the film table.

SELECT film.title, film.release_year

FROM film

• FROM film: We again select data from the film table.

• JOIN language ON film.language_id = language.language_id: This is the same JOIN operation as in the previous query, linking the film and language tables based on language_id.