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
8. Task 3

Instruction

Good job! You're really helping Mary and Tom!

Mary notices two interesting subcategories in flowering bulbs: crocuses and daffodils. Which flowers are for sale in these two subcategories? These flowers look so beautiful in the spring. Tom will be delighted!

Exercise

Write a query that shows the names of flowers (name the column flower_name) in the categories 'crocuses' and 'daffodils'. It should also show each flower's category (name the column category_name). Sort records by category name and then by flower name, in ascending order.