Paytm Assistant Manager interview questions

You have a table employee_sales with columns employee_id, sale_date, and sale_amount. Each row represents a sale made by an employee on a specific date. Write a query to find the top-performing employee in each month (by total sale_amount). If two employees have the same total sales for a month, show both.