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
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, release date: 2014, replacement cost: 20.99, rating PG-13, special features: Trailers
Next, 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**
SQL Queries in MySQL
This is using the Sakila Sample database which can download here:
https://dev.mysql.com/doc/sakila/en
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, release date: 2014, replacement cost: 20.99, rating PG-13, special features: Trailers
Next, 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**
SQL Queries in MySQL
This is using the Sakila Sample database which can download here:
https://dev.mysql.com/doc/sakila/en
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, release date: 2014, replacement cost: 20.99, rating PG-13, special features: Trailers
Next, 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**
Solution
Insert Query :
INSERT INTO film_text
(film_id,title,description,realease year,language_id,original_language_id,rental_duration,rental_rate,length,release date,replacement cost,rating,features)
VALUES
(\'1001\',\'1st Grade FBI Agent\',\'An undercover FBI agent must pretend to be a 1st grade teacher to catch the bad guy\',\'2014\',2,NULL,5,4.99,123,\'2014\',20.99,\'PG-13\',\'Trailers\');
Select Query :
SELECT title, description FROM film_text A JOIN language B
ON A.language_id=B.language_id
WHERE B.name <> \'English\' ;
