What you need to do . You will use the SAKILA schema in this assignment e Only s

Question

What you need to do . You will use the SAKILA schema in this assignment e Only submit the hw3.txt file to Blackboard 1) The SAKILA schema contains information on films and their languages. Use your All questions are one (1) point each. knowledge of joins to return the list of movies and their language names, such that the output looks like + includes title ACE GOLDFINGER English ADAPTATION HOLES English AFFAIR PREJUDICE English AFRICAN EGG name English AGENT TRUMAN EnglishI AIRPLANE SIERRA English 2) Now write a SQL query that uses a left outer join to find the distinct set of languages that is used by at least one film. Your result should look like: name English

Explanation / Answer

If you have any doubts, please give me comment....

1)

SELECT title, L.name

FROM films F INNER JOIN language L ON F.language_id = L.language_id;

2)

SELECT DISTINCT L.name

FROM language L LEFT OUTER JOIN films F ON L.language_id = F.language_id;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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