You have a database that contains the tables shown in the exhibit. You have an application named
App1. You have a parameter named @Count that uses the int data type. App1 is configured to
pass @Count to a stored procedure. You need to create a stored procedure named usp_Customers
for App1. Usp_Customers must meet the following requirements:
– NOT use object delimiters.
– Minimize sorting and counting.
– Return only the last name of each customer in alphabetical order.
– Return only the number of rows specified by the @Count parameter.
– The solution must NOT use BEGIN and END statements.

Which code segment should you use? To answer, type the correct code in the answer area.

Answer: See the explanation

Explanation:
CREATE PROCEDURE usp_Customers @Count int
AS
SELECT TOP(@Count) Customers.LastName
FROM Customers
ORDER BY Customers.LastName