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
4. flower table
Resolve tasks

Instruction

The third table, flower, stores details about the flowers sold by John in his garden store.

Exercise

The flower table contains these columns:

  • id – The unique ID of that flower.
  • name – The flower's name.
  • category_id – The ID of that flower's category (i.e. its immediate category, without any parent categories).
  • height - The flower's maximum height, in cm, as an integer.
  • bloom_month_from - The month when the flower begins to bloom. The month is an integer from 1 to 12, where 1 is January and 12 is December.
  • bloom_month_to - The month when the flower stops blooming. The month is an integer from 1 to 12, where 1 is January and 12 is December.

Select all data from the table flower.