Solution to Activity 5.1

In this activity, you will execute a few queries to get data that can be used by a manager for marketing and to reduce costs. Follow these steps to complete this activity:

1. Open the MySQL client and connect to the sakila database:

   USE sakila;

2. Find the total number of films the store has with a PG rating. To do this, you need both the film table and the inventory table. For every item in the inventory table, there is a reference to a record in the film table. Then, filter on the rating, which is stored in the film table. And finally, do SELECT COUNT(*) because all you need is the total number aggregated over all rows:

   SELECT COUNT(*)
   FROM film f
   JOIN inventory i ON f.film_id=i.film_id
   WHERE f.rating='PG';

The preceding query produces the following output:

Figure 16.31 – The SELECT output with the total number of PG-rated films in the inventory

3. Now, find films in which Emily Dee has performed as an...