$4\mathrm{.}11$ 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.

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

ACTIVITY

$\frac{0}{10}$

Main.sql

Load default template...