QuestionQ73
VerifiedPrepare dataYou have a Fabric lakehouse named Lakehouse1 that contains the following data.

Build a T-SQL statement that returns the total sales amount by OrderDate only for dates that are holidays in Australia. The total sales amount must add the quantity multiplied by the price for every row in the dbo.sales table.
How should you complete the statement?
Select
SELECT s.OrderDate, AS TotalSalesAmt FROM [Lakehouse1].[dbo].[sales] AS s JOIN [Lakehouse1].[dbo].[publicholidays] AS ph ON s.OrderDate = ph.date WHERE ph.countryOrRegion = 'Australia' GROUP BY s.OrderDate
Community Discussion