Question $15(1$ point$)$

Which SQL query retrieves the average order amount for each customer who placed more than $5$ orders from the "orders" table?

SELECT customer$\_$id$,$ AVG$($order$\_$amount$)$ FROM orders HAVING COUNT$($order$\_$id$)>5$ GROUP BY customer$\_$id

SELECT customer$\_$id$,$ AVG$($order$\_$amount$)$ FROM orders WHERE COUNT$($order$\_$id$)>5$ GROUP BY customer$\_$id

SELECT customer$\_$id$,$ AVG$($order$\_$amount$)$ FROM orders GROUP BY customer$\_$id WHERE COUNT$($order$\_$id$)>5$

SELECT customer$\_$id$,$ AVG$($order$\_$amount$)$ FROM orders GROUP BY customer$\_$id HAVING COUNT$($order$\_$id$)>5$