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 – May 2020

Introduction
Tasks
6. Task 1

Instruction

Lisa wants to analyze some bakery data. First, she wants to look at purchase patterns and prepare for this month's (May's) cake sales. To do this, she needs to know which cakes were bought in May 2019. Could you help her find out?

Exercise

Write a query to select the distinct names of cakes purchased in May 2019. Don't change the column name.

The purchase_date column contains only data from year 2019.

Stuck? Here's a hint!

In WHERE, use EXTRACT(date_part_name FROM column_name).

Need more help? Check out this exercise in Standard SQL Functions course.