You are presented with the following query.

Rewrite the query to improve its performance. Show the execution plan before and after your change.

SELECT customer.customer$\_$id$,$ COUNT$($rental$.$rental$\_$id$)$ AS num$\_$rentals

FROM customer

LEFT JOIN rental ON customer.customer$\_$id $=$ rental.customer$\_$id

GROUP BY customer.customer$\_$id