>For finding the maximum rating that a particular account had from 2011 through 2013, the output should look like this:
>
>

>Account    mYear    MaxRatings
>31425       2012        4.77
>87625       2013        1.23
>

>
>For finding the max rating, by account, and from 2011 through 2013, the output should look like this:
>
>

>Account    mYear    mMonth MaxRatings
>31425       2012        6             4.77
>87625       2013        9             1.23
>

>
>Thank you!!

Ok, good.

Now, based on all queries I already gave you, would you be able to create working queries to produce the output you need?

Please post what you come up with.

BTW, please enable AutoQuote in UT. To do so click on the Options menu of the message and check the 'Enable AutoQuote' option at the bottom.