I have a query which calculates the number of events during an hour by the minute. It needs to work out which minute has the most events and the average events during that hour. So it should return an array of 60 results for an hour where I can use the MAX() feature in php to find the peak minute.
You may find it easier to write an aggregate function and use that.
http://www.sqlite.org/capi3ref.html#sqlite3_create_function
If you aren't using the SQLite C api directly, then the wrapper you use may provide this ability.
Roger