Microsoft
70-457 · Question #30
You support a database structure shown in the exhibit. (Click the Exhibit button.) You need to write a query that displays the following details: - Total sales made by sales people, year, city, and…
Sign in or unlock 70-457 to reveal the answer and full explanation for question #30. The question stem and answer options stay visible for context.
Manage Data
Question
You support a database structure shown in the exhibit. (Click the Exhibit button.) 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?
Exhibits
Options
- AOption A
- BOption B
- COption C
- DOption D
Unlock 70-457 to see the answer
You've previewed enough free 70-457 questions. Unlock 70-457 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#GROUPING SETS#ROLLUP#aggregation#T-SQL