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

LAB

ACTIVITY

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

$\frac{0}{10}$

$$

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. The tables are initialized with LOAD rather than INSERT statements. The LOAD statements read data from $.$ csv files. In these files, $\backslash$N represents NULL.

Write a statement that selects the titles of films with the fewest rows in the inventory table.

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

$(3)$ History

Tutorial

$(34)$

Initialize.sql

Main.sql

$21$

$22--$ Use the following subquery:

$23$

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

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

$25$ FROM inventory

$26$ GROUP BY film$\_$id $)$

$27$

AS temp$\_$table $)$;