$4\mathrm{.}7$ LAB $-$ Nested aggregates $($Sakila$)$

Refer to the film and inventory tables of the Sakila database. The tables in this lab have the same columns and data types but fewer rows.

Write a query that lists the titles of films with the fewest rows in the inventory table.

This query requires a subquery that computes the minimum of counts by film$\_$id:

SELECT MIN $($count$\_$film$\_$id$)$

FROM $($ SELECT COUNT$($film$\_$id$)$ AS count$\_$film$\_$id

FROM inventory

GROUP BY film$\_$id $)$

As temp$\_$table;

This subquery is provided in the template.

$5451404053812$ qx$3$zqy $7$

LAB

$4\mathrm{.}7\mathrm{.}1$: LAB $-$ Nested aggregates $($Sakila$)$

Main.sql

Load default template...

$11234$

$($ SELECT MIN$($count$\_$film$\_$id$)$ FROM

$($ SELECT COUNT $($film$\_$id$)$ AS count$\_$film$\_$id

FROM inventory

GROUP BY film$\_$id $)$

AS temp$\_$table $)$;