You support a database structure shown in the exhibit.

You need to write a query that displays the following details:
– Total sales made by sales people, year, city, and country.
– Sub totals only at the city level and country level.
– A grand total of the sales amount.
Which Transact-SQL query should you use?

A.
Option A

B.
Option B

C.
Option C

D.
Option D

Explanation:
The question about BlogEntry is wrong. We need to “append” the text, with the query proposal in
the answer, we overwrite the whole string. The correct answer to this question is C.
http://www.grapefruitmoon.net/diving-into-t-sql-grouping-sets/
http://msdn.microsoft.com/en-us/library/ms177673.aspx