Okay, so i'm having trouble with aggregation and subqueries. I'm slowly starting to get it but i've hit a bit of a snag.
Here's what i'm trying to do...
In a table i'm working with, there is a 'pubdate' column of type 'date'. I need to to count the number of occurrences of books published in each month using the extract function. I've managed to extract the month from each date but i'm not sure how to count the dates.
SELECT EXTRACT(MONTH FROM pubdate) FROM titles;
^^ THat's how I got the month from the dates but I'm a little foggy on how to count each month occurence. Any help would be much appreciated.