1. Write a PIVOT query that can place the countries in the rows (down the page)...

Transcribed Image Text:

1. Write a PIVOT query that can place the countries in the rows (down the page) and years in columns across the page 2. Copy your SQL code into the word processing document (into an appendix) 3. Screenshot the dataset produced by the PIVOT query and also copy that image into the appendix. Verify that the numbers match the matrix report created in PowerBl. 1. Write a PIVOT query that can place the countries in the rows (down the page) and years in columns across the page 2. Copy your SQL code into the word processing document (into an appendix) 3. Screenshot the dataset produced by the PIVOT query and also copy that image into the appendix. Verify that the numbers match the matrix report created in PowerBl.

Answer rating: 100% (QA)

Answer Heres a sample SQL query for pivoting data where countries are placed in rows ... View the full answer