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

SQL Coding Challenge – March 2020

Introduction
Resolve tasks
15. Task 10

Instruction

Woohoo! The garden is almost done. There's one thing left.

Mary and Tom plan to plant flowers shorter than the average maximum height of all flowers. The flowers they will plant are the ones that are not in the main categories 'herbs' and 'flowering bulbs'.

Exercise

Find the names (as flower_name), height, and categories of the flowers (as category_name) that meet the following conditions:

  • The flower's height is lower than the average height of all flowers.
  • It does not belong to the 'herbs' or 'flowering bulbs' main categories (or any of their subcategories).