Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In this exercise, you will be working with the Sakila MySQL database. If needed, it can be downloaded from:http://dev.mysql.com/doc/sakila/en/sakila-installation.html Examine the structure of the tables

In this exercise, you will be working with the Sakila MySQL database. If needed, it can be downloaded from:http://dev.mysql.com/doc/sakila/en/sakila-installation.html

Examine the structure of the tables in MySQL workbench. Run the following queries:

1. How many distinct countries are there? 2. Find out the top 5 countries with most number of clients. 3. What are the names of all the languages in the database (sorted alphabetically)? 4. Return the full names (first and last) of actors with SON in their last name, ordered by their first name. 5. Create a list of films and their corresponding categories. 6. Create a list of categories and the number of films for each category. 7. Create a list of actors and the number of movies by each actor. 8. List the film_id and titles of those films that are not in inventory. 9. Find a list of customers who have not rented a movie yet. 10. Find the number of English films in the category of Documentary.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Will we be able to keep up with company growth?

Answered: 1 week ago

Question

1. Prepare a flowchart of Dr. Mahalees service encounters.

Answered: 1 week ago