Câu 16: 70-761: Querying Data with Transact-SQL

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question. You have a database that contains several connected tables. The tables contain sales data for customers in the United States only. You have the following partial query for the database. (Line numbers are included for reference only.) You need to complete the query to generate the output shown in the following table. Which statement clause should you add at line 3?

1. A. GROUP BY
2. B. MERGE
3. C. GROUP BY ROLLUP — đáp án hiện tại
4. D. LEFT JOIN
5. E. GROUP BY CUBE
6. F. CROSS JOIN
7. G. PIVOT
8. H. UNPIVOT