select account, mHour, MAX(mRating) as MAxRating FROM Ratings GROUPBY 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.