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
6. Task 1

Instruction

John is Tom's best friend, so it's not surprising that Mary and Tom decided to go to him to buy flowers for their new garden!

First, they would like to find out what the main categories of flowers are. Are you ready to help them?

Exercise

Select the names of all main categories (those without a parent category) from the table category.

Stuck? Here's a hint!

Use IS NULL to check if a category doesn't have a parent category.