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
9. Task 4

Instruction

Fantastic! Mary and Tom will buy all the flowers in the 'crocuses' and 'daffodils' categories.

This is not the end of their purchase. Every year, Tom has time off from his job in May. Therefore, he wants to see flowers in this month. Mary likes flowers under 50 cm tall, so he needs to find flowers below 50 cm that start blooming in the month of May. Can you help him?

Exercise

Write a query that selects the name, height, and starting and ending blooming months – but only for flowers where blooming starts in May and the height is below 50 cm.