Based on the following schema, use SQL to make a list of actors and film title w

Question

Based on the following schema, use SQL to make a list of actors and film title where the movie is in English.

tfilm id SMALLINT description TEAT Orelease year YEAR. language id TINYINT originaUanguage-i. Orental duration TIN. DECIMA... Al----- rental.rate length SMALLINT replacement cost D Indexes idx title idx-kJanguage, jd idx original langua... AFT UPDATE upd film Movie database film cate. lfilm.d SMALLINT categoryJd TINYI last update TIME... language-id TINY. Oname CHAR(20) 4H Qlast-update TIME. category-d TINYI... name VARCHAR(25) Olast update TIME... factor jd SMALLINT first name VARCH last warme VARCH... Glast update TIME. PRIMARY ido actor Jast name film actor actor jd SMALLINT filmud SMALLINT last update TIME.

Explanation / Answer

The solution for the above question can be done using nested queries.

Select firstname from actor where actor_id=(select actor_id from flim_actor where film_id=(select flim_id from film where lang_id=(select lang_id from language where name="English")));

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

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