Homework SourseSQL Queries in MySQL This is using the Sakila Sample databas
SQL Queries in MySQL
This is using the Sakila Sample database which can download here:
https://dev.mysql.com/doc/sakila/en
Instructions:
Add a row to the Film Database before working on this query. This new film is the only result you should get.
film_id 1001, title: 1st Grade FBI Agent, description: An undercover FBI agent must pretend to be a 1st grade teacher to catch the bad guy realease year: 2014, language_id: 2, original_language_id: null, rental_duration: 5, rental_rate: 4.99, length: 123, replacement cost: 20.99, rating PG-13, special features: Trailers
Write a query that produces the title and description of all films that are not in English.
**Note that you will be performing a query on multiple tables. See below.**
Schema: sakila
Tables Used
Table Name: film
Column Names: film_id, title, description, release_year, language_id, original_language_id, rental_duration, rental_rate, length, replacement_cost, rating, special_features
Table Name: language
Column Names: language_id, name, last_update
(*note on language_id\'s: 1=English, 2=Italian, 3=Japanese, 4=Mandarin, 5=French, 6=German)
SQL Queries in MySQL
This is using the Sakila Sample database which can download here:
https://dev.mysql.com/doc/sakila/en
Instructions:
Add a row to the Film Database before working on this query. This new film is the only result you should get.
film_id 1001, title: 1st Grade FBI Agent, description: An undercover FBI agent must pretend to be a 1st grade teacher to catch the bad guy realease year: 2014, language_id: 2, original_language_id: null, rental_duration: 5, rental_rate: 4.99, length: 123, replacement cost: 20.99, rating PG-13, special features: Trailers
Write a query that produces the title and description of all films that are not in English.
**Note that you will be performing a query on multiple tables. See below.**
Schema: sakila
Tables Used
Table Name: film
Column Names: film_id, title, description, release_year, language_id, original_language_id, rental_duration, rental_rate, length, replacement_cost, rating, special_features
Table Name: language
Column Names: language_id, name, last_update
(*note on language_id\'s: 1=English, 2=Italian, 3=Japanese, 4=Mandarin, 5=French, 6=German)
SQL Queries in MySQL
This is using the Sakila Sample database which can download here:
https://dev.mysql.com/doc/sakila/en
Instructions:
Add a row to the Film Database before working on this query. This new film is the only result you should get.
film_id 1001, title: 1st Grade FBI Agent, description: An undercover FBI agent must pretend to be a 1st grade teacher to catch the bad guy realease year: 2014, language_id: 2, original_language_id: null, rental_duration: 5, rental_rate: 4.99, length: 123, replacement cost: 20.99, rating PG-13, special features: Trailers
Write a query that produces the title and description of all films that are not in English.
**Note that you will be performing a query on multiple tables. See below.**
Schema: sakila
Tables Used
Table Name: film
Column Names: film_id, title, description, release_year, language_id, original_language_id, rental_duration, rental_rate, length, replacement_cost, rating, special_features
Table Name: language
Column Names: language_id, name, last_update
(*note on language_id\'s: 1=English, 2=Italian, 3=Japanese, 4=Mandarin, 5=French, 6=German)
Solution
Write a query that produces the title and description of all films that are not in English:
SELECT film.title, film.description
FROM film
INNER JOIN language ON (language.language_id = film.language_id)
WHERE language.name = \'English\'
