Review the SQL below and execute it on the sakila database to see the results. Then answer the following questions:

How many subqueries are used?

How many different types of subqueries are used? Describe each type. $($Note that some subqueries may be examples of more than one type.$)$

What information is the query providing? $($Ignore the LIMIT $25$ because it is only there for convenience.$)$

WITH unreturned$\_$film$\_$list AS

$($

SELECT DISTINCT f$.$film$\_$id

FROM rental r

JOIN inventory i

ON r$.$inventory$\_$id$=$i$.$inventory$\_$id

JOIN film f

ON i$.$film$\_$id$=$f$.$film$\_$id

WHERE

r$.$return$\_$date IS NULL

$),$

inventory$\_$list AS

$($

SELECT DISTINCT f$.$film$\_$id$,$ i$.$inventory$\_$id

FROM inventory i

JOIN film f

ON i$.$film$\_$id$=$f$.$film$\_$id

WHERE

f$.$film$\_$id IN$($SELECT f$.$film$\_$id FROM unreturned$\_$film$\_$list$)$

$),$

unreturned$\_$inventory$\_$list AS

$($

SELECT DISTINCT f$.$film$\_$id$,$ i$.$inventory$\_$id

FROM rental r

JOIN inventory i

ON r$.$inventory$\_$id$=$i$.$inventory$\_$id

JOIN film f

ON i$.$film$\_$id$=$f$.$film$\_$id

WHERE

r$.$return$\_$date IS NULL

$)$

SELECT

f$.$film$\_$id AS $`$Film ID$`,$

f$.$title AS Title,

$($SELECT COUNT$($DISTINCT il$.$inventory$\_$id$)$ FROM inventory$\_$list il WHERE il$.$film$\_$id$=$f$.$film$\_$id$)$ AS $`$In Inventory$`,$

$($SELECT COUNT$($DISTINCT uil.inventory$\_$id$)$ FROM unreturned$\_$inventory$\_$list uil WHERE uil.film$\_$id$=$f$.$film$\_$id$)$ AS $`$Rented Out$`,$

$($SELECT COUNT$($DISTINCT il$.$inventory$\_$id$)$ FROM inventory$\_$list il WHERE il$.$film$\_$id$=$f$.$film$\_$id$)$

$-($SELECT COUNT$($DISTINCT uil.inventory$\_$id$)$ FROM unreturned$\_$inventory$\_$list uil WHERE uil.film$\_$id$=$f$.$film$\_$id$)$ AS $`$In Stock$`$

FROM

film f

LIMIT $25$;