DRAG DROP
You use Microsoft SQL Server 2012 to develop a database application.
You create two tables by using the following table definitions.
Which six Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the
correct order.)
Answer: 
Explanation:
There should be 6 statements in the answer.
I was also confused with “6” but those five parts looks correct.
How can there be a join to the employee_subtree in the selection for creating the employee_subtree CTE?
@et: CTE’s allow self-referencing. An outer query can reference an inner query comprising the same query text as itself, but with different aliases.
SElECT * is bad practice. Should not be on exam…
I guess its ok, given the context.
One of our guests not long ago advised the following website.