Write a stored procedure that returns the name and salary of the highest paid employee from a table of data.
About this solution: The candidate's solution is correct and demonstrates a good understanding of how to solve the problem. The approach is efficient and uses a subquery to find the maximum salary, which is then used to return the name and salary of the employee with that salary.
Write a stored procedure that returns the top 10 products by sales from a given table.
About this solution: The candidate's solution is optimal and demonstrates a complete understanding of how to write a stored procedure to return the top 10 products by sales.