QuestionQ73

VerifiedPrepare data

You have a Fabric lakehouse named Lakehouse1 that contains the following data.

Question Image

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?

Community Discussion

No comments yet. Be the first to start the discussion!