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