Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Creating Basic SQL Reports

Introduction
Basic multi-level aggregation
Multi-level aggregation in groups
Multi-level aggregation with custom classification
12. Multi-level aggregation with CASE WHEN – exercise
Three or more aggregation levels
Summary

Instruction

Good job! Let's do one more exercise before we go to the next kind of multi-level aggregation.

Exercise

What is the average number of products in non-vegetarian (category_id 6 or 8) and vegetarian categories (all other category_id values)? Show two columns: product_type (either 'vegetarian' or 'non-vegetarian') and avg_product_count.

Stuck? Here's a hint!

In the inner query, create a CASE WHEN expression to check the category_id value and show either 'non-vegetarian' or 'vegetarian'. Then, in the outer query, use that column with the AVG() function. You need to use only one table – products.