Exercise

Testing out your new VIEW

You are interested in calculating the average movie length for every category. Which tables & columns will you need to create this query?

Note: The table_columns view is now stored in your database and can be used to help you with this question.

50 XP

Tables: inventory & category -- Join on: film_id

Tables: rental & inventory -- Join on: inventory_id

Tables: film & category -- Join on: film_id

None of the above