\! echo Which actors have the first name 'Scarlett'

\! echo Which actors have the last name 'Johansson'

\! echo How many distinct actors last names are there?

\! echo Which last names are not repeated?

\! echo Which last names appear more than once?

\! echo Which actor has appeared in the most films?

\! echo Is 'Academy Dinosaur' available for rent from Store 1?

\! echo Step 1: which copies are at Store 1?

\! echo Step 2: pick an inventory_id to rent:

\! echo Insert a record to represent Mary Smith renting 'Academy Dinosaur' from Mike Hillyer at Store 1 today .

\! echo When is 'Academy Dinosaur' due?

\! echo Step 1: what is the rental duration?

\! echo Step 2: which rental are we referring to -- the last one.

\! echo Step 3: add the rental duration to the rental date.

\! echo What is that average running time of all the films in the sakila DB?

\! echo What is the average running time of films by category?

\! echo Why does this query return the empty set?

select * from film natural join inventory;
