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

Standard SQL Functions

Final Quiz
8. Exercise 6

Instruction

Cool! Just a few more!

Exercise

Count the number of people who registered in each month of 2015. Name the columns month and people_no. The month should be expressed as a number, e.g. 3.0 (you don't need to cast it to some other type). Don't show months where no registrations took place.

Stuck? Here's a hint!

To extract the month from the registration_date, you should type: EXTRACT(MONTH FROM registration_date).