SELECT service_broker_guid
   FROM sys.Databases
  ORDER BY CASE 
           WHEN database_id < = 4
           THEN N' ' + name
           ELSE CAST(create_date AS NVARCHAR(128))
            END

ALTER TABLE dbo.yourtablename
ADD Results1 AS Col1 * 1.57 / Col2 * CASE WHEN Col3 = 'A' THEN Col4 ELSE Col5 END

SELECT
    Results1, Colx / Results1 AS ...
FROM dbo.yourtablename
WHERE
    Results1 >= 9.75
GROUP BY
    Results1
ORDER BY
    Results1

SELECT RTRIM(c2) AS c1, RTRIM(c1) AS c2 
FROM (
    SELECT 'Y' AS c1, 'Z' AS c2 UNION ALL
    SELECT 'C' AS c1, 'D' AS c2 UNION ALL
    SELECT 'A' AS c1, 'B' AS c2
) AS test_data
ORDER BY c1