I have a Statistics section were I want to be able to display the year, month and day with the most registrations(for meetings).
There are registrations from 2005-Now. What I want to display is what year that have the most registrations, what month 8For example april 2009) and what day(example December 2nd 2010).
The regsitrations is stored like this "2010-12-24 15:30:45" (Swedish date).
Data type = datetime
I need to count the rows and select the one with the most..
How can I achieve this in my select statements?
Example, End result:
The year with most registrations: 2009, 11876
The month with the most registrations: May 2010, 2983
The day with the most........ September 27nd 2011, 312