DRAG DROP
You create three tables by running the following Transact-SQL statements:
For reporting purposes, you need to find the active user count for each role, and the total active user count. The result must be ordered by active user count of each role. You must use common table expressions (CTEs).
Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-
SQL segments to the answer area and arrange them in the correct order.
Select and Place:
Correct Answer: 2,3,6 and 1
You can not use ORDER BY inside the cte. However, you can have ORDER BY in the query which is selecting from cte. In this question 2,3 and 6 are Common table expressions and 1 is the query which is selecting the cte.