Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
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 (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).