Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 5 of 40
Free Preview · 40 of 131 · questions 1–40 of 131 are free. Sign up free to sync your progress across devices.
Hot Area / Sentence Completion
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Hotspot Solution:
SELECT YEAR(SO.ModifiedDate) AS OrderDate, P.Name AS ProductName, SUM(SO.OrderQty) AS OrderQty FROM [dbo].[SalesOrderDetail] SO INNER JOIN [dbo].[Product] P ON P.ProductID = SO.ProductID GROUP BY ROLLUP(YEAR(SO.ModifiedDate), P.Name) ORDER BY OrderDate;
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
SELECT YEAR(SO.ModifiedDate) AS OrderDate, P.Name AS ProductName, SUM(SO.OrderQty) AS OrderQty FROM [dbo].[SalesOrderDetail] SO INNER JOIN [dbo].[Product] P ON P.ProductID = SO.ProductID GROUP BY ROLLUP(YEAR(SO.ModifiedDate), P.Name) ORDER BY OrderDate;
what is meant by "correct Answer A" !?
select year(), grouping sets