Which Transact-SQL code segment should you run?

Posted by: Pdfprep Category: 70-761 Tags: , ,

You run the following Transact-SQL statement:

You need to create a query that returns the total number of attendees for each combination of CourseID, CourseDate, and the following locations: Lisbon, London, and Seattle. The result set should resemble the following:

Which Transact-SQL code segment should you run?

Answer: B

Explanation:

References: https://www.techonthenet.com/sql_server/pivot.php

Leave a Reply

Your email address will not be published.