Exercise

Subqueries

Pissa, the expanding pizza delivery enterprise, is now using your expertise to identify some trends.

They want to streamline its pizza offerings by identifying under-performing pizzas. Your task is to find the pizza types ordered less frequently than the average for all types.

Instructions

100 XP

Fill in the subquery to find the AVG of total_quantity.
Calculate total_quantity within the subquery.
Alias the subquery as subquery.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise