SELECT TOP 1 p.PromotionId AS [Promotion ID], p.PromotionName AS [Promotion Name], SUM(oi.LineTotal) AS [Total Revenue] FROM dbo.ProductPromotions pp JOIN dbo.Promotions p ON pp.PromotionId = p.PromotionId JOIN dbo.OrderItems oi ON pp.ProductId = oi.ProductId GROUP BY p.PromotionId, p.PromotionName ORDER BY [Total Revenue] DESC, p.PromotionId

SELECT [PhoneCalls].[Id] AS [Phone Call ID], [PhoneCalls].[PhoneNumber] AS [Phone Number], [PhoneCalls].[StartCall] AS [Start Call], [PhoneCalls].[EndCall] AS [End Call], [PhoneCalls].[CallDuration] AS [Call Duration], [PhoneCalls].[Transcription] AS [Transcription]
FROM [dbo].[PhoneCalls]
INNER JOIN [dbo].[Customers] ON [PhoneCalls].[CustomerId] = [Customers].[Id]
WHERE [Customers].[Name] = 'TNUFA' AND MONTH([PhoneCalls].[StartCall]) = MONTH(GETDATE()) AND YEAR([PhoneCalls].[StartCall]) = YEAR(GETDATE())
ORDER BY [PhoneCalls].[StartCall] DESC;