I have a table called 'suggestions' where I have 'suggestionDate' and some other fields. 'suggestionDate' has value like '9/12/2007'. The table will have information on number of suggestions per year. I need an output like 'Number of Suggestions Per Year' as follows.
How can I do that ? I have only a clue that I need to use DISTINCT, YEAR function, GROUP BY and ORDER BY. But, I could not figure out the exact query to get the above resultset. Please help.