gistfile1.sql

SELECT [Year], [Month], [Description], SUM(RenewalPrice)
FROM (
     SELECT YEAR(CONVERT(datetime, Subscription__r_Renewal_Date__c)) AS [Year], MONTH(CONVERT(datetime, Subscription__r_Renewal_Date__c)) AS [Month], CONVERT(nvarchar(500), [Description]) AS [Description], Subscription__r_Renewal_Price__c AS [RenewalPrice]
     FROM OPENQUERY(DBAMP, '
          SELECT Id, Description, Subscription__r.Renewal_Date__c, Subscription__r.Renewal_Price__c
          FROM Asset
     ')) AS tmp
GROUP BY [Year], [Month], [Description]
ORDER BY [Year], [Month], [Description]