Your question is Understanding Stored Procedures in SQL. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
What is a stored procedure in SQL? Discuss its purpose, how it differs from regular SQL statements, and when it is beneficial to use them.
The interviewer expects a clear explanation of what stored procedures are, their advantages, and examples of scenarios where they are particularly useful.