Solutions:
Check these solutions from our community and artificial intelligence:
The solution is optimal because it uses the ORDER BY clause to sort the table by purchase_amount in descending order, and then uses the LIMIT clause to return the first 10 rows.