The stored procedure will take in a customer ID as input and return the customer's name and address.
Write a stored procedure that will take in a customer ID as input and return the customer's name and address.
Name: John Doe
Address: 123 Main Street
SELECT name, address
WHERE customer_id = 123
This is optimal because it is a simple query that will return the information we need.
The candidate's solution is complete and solves the problem. The approach is straightforward and efficient.
Evaluated at: 2022-11-15 08:15:17