How should you complete the Transact-SQL statement?

DRAG DROP
You need to build a function that meets the following requirements:
• Returns multiple rows
• Optimizes the performance of the query within the function
How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL statements to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

Correct Answer:

Explanation/Reference:
https://technet.microsoft.com/en-us/library/ms189294(v=sql.105).aspx