SQL Queries in MySQL This is using the Sakila Sample database which can download

Question

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**

Explanation / Answer

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' ;

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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