Display Discount Name in an SQL Report

Hello
I am using “NopCommerce SQL Report” plugin by nop4u to generate reports. I want to get the name of the discounts for my products in orders but I cant fissure out how to do so.
I would appreciate any help.
Thank you.

Hi,
Please check this T-SQL Query:

select T0.Id, T0.CreatedOnUtc, T0.OrderTotal, T2.[Name] from [Order] T0
left join [DiscountUsageHistory] T1 on T1.OrderId = T0.Id
left join [Discount] T2 on T2.Id = T1.DiscountId

Best Regards
Krzysztof

Thank you for your quick response.
I will check this solution.
Best regards.