How to arrange data in your SQL statement

I have attached a PDF so you can see what I am talking about.

In the matrix I have Prospect Status and Rating Description.  How can I move around each field in the Rating Description.  Example

$1-$2999
$40000 - $50000

I want to arrange these in the correct order in the report or sql statement.

SELECT     DCons_ProspectStatus, DConRtng_RatingDescription, COUNT(DSol_ConstituentID) AS Expr1, DSol_ConstituentID, DSol_FullName
FROM         DR_SolicitorRelations
GROUP BY DCons_ProspectStatus, DConRtng_RatingDescription, DSol_ConstituentID, DSol_FullName

Select allOpen in new window

PMR1020-march-13.pdf