select account, mHour, MAX(mRating) as MAxRating FROM Ratings GROUP BY account, mHour, mRating

gives me losts of results -- presumable the max of the 15 minutes ratings in any given hour.
But--without writing a whole program--can I use SQL to show each account's
maximum rating in a given year or a given month.
Thank you again.