SELECT [January] AS Jan,[February] AS Feb,[March] AS Mar,[April] AS Apr,[May] AS May,[June] AS Jun,[July] AS Jul,[August] AS Aug,[September] AS Sep,[October] AS Oct,[November] AS Nov,[December] AS Dec,CountryCode FROM ( SELECT [Month_Name], RateTotal / 7 as RateTotal,CountryCode FROM [cartrawler_v2].[dbo].[LocationVehicleHistoryV2] WHERE VehicleMatrixCategory in ('Compact','Economy','Fullsize','Intermediate','Luxury','Mini','Standard') AND CountryCode IN ('AU','ES','CY','FR','DE','GR','is','IT','NL','PT','ZA','ES','CH','TR','AE','GB','US') ) AverageRates PIVOT( Min(RateTotal) FOR [Month_Name] IN( January, February, March, April, May, June, July, August, September, October, November, December ) ) AS PivotTable ORDER BY CountryCode
//]]>