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).
