Exam 70-461 topic 1 question 241 discussion

DRAG DROP -
You use Microsoft SQL Server Management Studio to develop a Microsoft Azure SQL Database instance that will support a purchase order application.
You write the following query:

A partial view of the query results can be seen in the following table.

You must generate a summary report that displays the total number of purchase orders received by each vendor for the following regions: North, East, South,
West, and Central.
You need to write a query that returns the results in the format shown in the following table.

Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-
SQL segments to the answer area and arrange them in the correct order.
Select and Place:

Suggested Answer:
Step 1: SELECT Vendorname, [North], [East],..FROM SourceTable
Step 2: WITH SourceTable AS..
Step 3: UNPIVOT ..
UNPIVOT carries out almost the reverse operation of PIVOT, by rotating columns into rows.
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot