Using this schema, please answer the following question (SQL) http://dcm.uhcl.ed

Question

Using this schema, please answer the following question (SQL)

http://dcm.uhcl.edu/yue/courses/csci5333/Fall2017/Notes/Query/sakila-schema.sql.txt

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

Explanation / Answer

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

SELECT f.title, f.release_year
FROM film f, language l
WHERE f.language_id = l.language_id AND l.name = "English"

====================================

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

SELECT f.title, f.release_year
FROM film f, language l
WHERE f.language_id = l.language_id AND l.name = "French"

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.