D$.$ Creating Indexes $(5$ points$)$

$1.$ Create an index on the last name column of the Rental Customers table.

E$.$ Creating Synonyms $(5$ points$)$

$1.$ Create a synonym called TU for the TITLE$\_$UNAVAIL view.

F$.$ Writing Queries $(20$ points$)$

Note: You may need to write INSERT statements to add more data to your tables.

$1.$ Read each of the questions listed in the left column of the table below.

$2.$ Write the answer to your question and$/$or the required SQL statement in the corresponding cell in the right column that answers the question. $($Test your statement to confirm the results before submitting.$).$

$\backslash$begin$\{$tabular$\}\{|$l$|$l$|\}$

$\backslash$hline a$.$ To determine the popularity of the movies in the $\backslash \backslash$

OracleFlix inventory, write a query to display each $\backslash \backslash$

movie and the number of times it was rented. Sort $\backslash \backslash$

your results by the count of rentals in descending $\backslash \backslash$

order. $\backslash \backslash$

$\backslash$hline b$.$ OracleFlix will be mailing coupons to the homes of $\backslash \backslash$

frequent renters. They are printing labels for each $\backslash \backslash$

customer. Write a query to identify the frequent $\backslash \backslash$

renters $($i$.$e$.,$ customers that have rented more $\backslash \backslash$

than once$).$ Your results should include the $\backslash \backslash$

customers' first and last name concatenated, $\backslash \backslash$

address, city, and state. Also include $2$ columns $-\backslash \backslash$

name length and address length $-$ that display $\backslash \backslash$

the length of the concatenation of the first and $\backslash \backslash$

last name and the length of the address. Sort your $\backslash \backslash$

results by the customers' last names.

$\backslash$end$\{$tabular$\}$

to identify movies with a release date of at least $25$ years ago $($i$.$e$.,1996$ or before$).$ Write a query that identifies these movies. Your results should include the release date and the movie title. Sort your results by release date.

G$.$ Creating Queries $(10$ points$)$

You have ideas for $2$ inventory and rentals reports that could be helpful to the leadership of the OracleFlix company. Develop the queries to support the reports you plan to propose and explain how they would be helpful to leadership.

Note: You may need to write INSERT statements to add more data to your tables.

$-$ Your query should include the SQL concepts, keywords, and$/$or clauses in column $1.-$ Test your statement to confirm the results before submitting and place your final query in the column $2.$

$-$ Describe the output of your query as if you were presenting it to a client $($e$.$g$.,$ what does it mean, how would it be useful to them$)$ in column $3$

$-$ Save this document once you have added your answers and uploaded it as part of your submission.