USE sakila;

SELECT last

$\_$

name, first

$\_$

name, ROUND

$($

AVG

$($

length

$)$

$,$

$0$

$)$

$$AS average

FROM actor

INNER JOIN film

$\_$

actor ON film

$\_$

actor.actor

$\_$

id

$=$

$$actor$.$actor

$\_$

id

INNER JOIN film ON film

$\_$

actor.film

$\_$

id

$=$

$$film$.$film

$\_$

id

WHERE title

$=$

$"$ALONE TRIP"

GROUP BY last

$\_$

name, first

$\_$

name

ORDER BY average; Now, replace $=$ in the WHERE clause with $<$ and generate a new execution plan. Step $1$ of the execution plan says Index Range Scan. The index scan accesses all films with titles preceding "ALONE TRIP", rather than a single film.

Finally, replace $<$ in the WHERE clause with $>$ and generate a third execution plan. Step $1$ of the execution plan says Full Table Scan and accesses actor rather than film.