Download the database from the following link if you don\'t have it already on y

Question

Download the database from the following link if you don't have it already on your local system. http://mysql-tools.com/en/downloads/mysql-databases/4-sakila-db.html It the result set is more than 10 lines please attach the screenshot rather than the result set (Snapshot) Write a SQL statement that returns all of the schemas in a your local database. Include your results. Write a SQL statement that returns all of the actors where the last_name is 'NOLTE'. Include your results. Write a SQL statement that returns all films whose description includes the word 'Berlin'. Include your results. Write a SQL statement that returns the count of films in the film table. How many total films in the film table have a 'G' rating? Write a SQL statement that returns the count of films with a 'G' rating. Write a SQL statement that returns the following information. No row should appear more than once in the output. Include your results. film id film title film rating film category

Explanation / Answer

Question 1:

Select * from all_users;

Question 2:

Select * from actor where last_name = 'NOLTE';

Question 3:

Select * from film where description like '%Berlin%;

Question 4:

Select count(*) from film;

Question 5:

Select count(*) from film where rating = 'G';

Question 6:

Select distinct f.film_id,f.title,f.rating,c.name from film f inner join film_category fc on f.film_id = fc.film_id inner join category c on fc.category_id = c.category_id;

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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