Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started