SELECT customer.name, SUM$($payment$.$payment$\_$amount$)$ FROM customer

JOIN payment ON customer.customer$\_$id $=$ payment.customer$\_$id

GROUP BY customer.name

WHERE payment.payment$\_$amount $>5000$

Why would this query not work as expected?

The WHERE clause should come before the GROUP BY clause

The SUM function function won't work with the payment$\_$amount column

The JOIN operation is performed incorrectly

The GROUP BY clause should come before the JOIN operation

The query is missing an ORDER BY clause