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. Input: 123 Output: Name: John Doe Address: 123 Main Street
/* Solution: SELECT name, address FROM customers 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