SELECT
           CASE
               WHEN SalesOrderHeader.SubTotal + SalesOrderHeader.TaxAmt + SalesOrderHeader.Freight < 100 THEN "0-99"
               WHEN SalesOrderHeader.SubTotal + SalesOrderHeader.TaxAmt + SalesOrderHeader.Freight BETWEEN 100 and 999 THEN "100-999"
               WHEN SalesOrderHeader.SubTotal + SalesOrderHeader.TaxAmt + SalesOrderHeader.Freight BETWEEN 1000 and 9999 THEN "1000-9999"
               WHEN SalesOrderHeader.SubTotal + SalesOrderHeader.TaxAmt + SalesOrderHeader.Freight >10000 THEN "RICH BITCH"
          END AS t,
          COUNT(*) AS Num,
            CASE
               WHEN SalesOrderHeader.SubTotal + SalesOrderHeader.TaxAmt + SalesOrderHeader.Freight < 100 THEN SUM(SalesOrderHeader.SubTotal + SalesOrderHeader.TaxAmt + SalesOrderHeader.Freight)
               WHEN SalesOrderHeader.SubTotal + SalesOrderHeader.TaxAmt + SalesOrderHeader.Freight BETWEEN 100 and 999 THEN SUM(SalesOrderHeader.SubTotal + SalesOrderHeader.TaxAmt + SalesOrderHeader.Freight)
               WHEN SalesOrderHeader.SubTotal + SalesOrderHeader.TaxAmt + SalesOrderHeader.Freight BETWEEN 1000 and 9999 THEN SUM(SalesOrderHeader.SubTotal + SalesOrderHeader.TaxAmt + SalesOrderHeader.Freight)
               WHEN SalesOrderHeader.SubTotal + SalesOrderHeader.TaxAmt + SalesOrderHeader.Freight >10000 THEN SUM(SalesOrderHeader.SubTotal + SalesOrderHeader.TaxAmt + SalesOrderHeader.Freight) END

FROM SalesOrderHeader
GROUP BY t