• This would be my ideal ranking. Using the 2008 year as an example

    Select 6,1028,'High' union all

    Select 2,924,'High' union all

    Select 3,862,'Medium' union all

    Select 4,724,'Medium' union all

    Select 5,628,'Medium' union all

    Select 1,569,'Low' union all

    Select 7,488,'Low' union all

    Select 8,321,'Low' union all

    Select 9,284,'Low' union all

    Select 10,161,'Low'

    In this case it breaks down to 32.5% high, 36.9% medium, 30.4% low.