DRAG DROP
You are developing a database to track customer orders. The database contains the following tables: Sales.Customers, Sales.Orders, and Sales.OrderLines.
The following table describes the columns in Sales.Customers.
The following table describes the columns in Sales.Orders.
The following table describes the columns in Sales.OrderLines.
You need to create a function that accepts a CustomerID as a parameter and returns the following information:
– all customer information for the customer
– the total number of orders for the customer
– the total price of all orders for the customer
– the average quantity of items per order
How should you complete the function definition? To answer, drag the appropriate TransactSQL segment to the correct locations. 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.
Answer: 
Latest 70-761 Dumps Valid Version with 212 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund