Question

List the maximum sale made by each employee.

Answer 1

SELECT employee_id, MAX(sale_amount) AS max_sale
FROM sales
GROUP BY employee_id;