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
10. Task 5

Instruction

Tom found two flowers that meet his requirements. It will be a surprise for Mary!

Mary wants to know how many flowers are in a special color. They want to buy flowers of the same color and plant them in a corner of the garden.

Exercise

Select color names and the number of the flowers in this color. Name the first column color_name and the second count_flowers.