For this question, you'll switch back to the Sakila database.

Your boss, at movies$-$rentals$-$to$-$go asks you to create a list of all the movies where the movie description contains either sharks,

cows or crocodiles that are either dramas, comedys, or character studies. They provide you this query, which gives them the results

they want, but the query isn't performant.

SELECT

film$\_$id$,$

title,

description

FROM

film

WHERE

$($description LIKE $\text{'}\%$shark$\%\text{'}$ OR

description LIKE $\text{'}\%$cow$\%\text{'}$ OR

description LIKE $\text{'}\%$crocodile$\%\text{'})$ and

$($description LIKE $\text{'}\%$drama$\%\text{'}$ OR

description LIKE $\text{'}\%$comedy$\%\text{'}$ OR

description LIKE $\text{'}\%$character study$\%\text{'})$ order by title;

Write a query using a full text index that gives the same results, but with better performance. Can you get an exact match? Why or

why not? If not, is there any way to adjust the query to get the same result?