Top Customers by Sales Revenue

Task

You are given a single sales table from a Deloitte reporting dataset. Write a PostgreSQL query to return the top 10 customers by total revenue. Revenue should be calculated as the sum of sale_amount for each customer, ignoring rows where sale_amount is NULL. Return the customer name and total revenue, sorted from highest to lowest revenue.