Your supervisor has asked you to write a report showing how many orders each customer has made. They are requesting that you show the customer ID$,$ e$-$mail, and the number of orders.

Write a select statement that returns one r $\frac{?}{\text{b}\text{a}\text{r}}($$$)$ w for each customer$\_$id showing the customer's ID$,$ email address, and COUNT of ORDER$\_$ID$.$ You will need to join two tables, OE$.$CUSTOMERS and OE$.$ORDERS. Use a LEFT JOIN. Do NOT use a natural join.

Grouping by CUSTOMER$\_$ID$,$ you will need to show the following columns:

The CUSTOMER$\_$ID column from the OE$.$CUSTOMERS table.

The CUST$\_$EMAIL column from the OE$.$CUSTOMERS table

The COUNT of ORDER$\_$ID from the OE$.$ORDERS table with an alias of NUM$\_$ORDERS

Sort the result set in ascending order by the CUSTOMER$\_$ID field

If you use a left join, you may get an "ORA$-00918$: column ambiguously defined" error. This is because the CUSTOMER$\_$ID is in both the OE$.$CUSTOMERS and OE$.$ORDERS table. You will need to either use a natural join or explicitly pick one, e$.$g$.$ OE$.$CUSTOMERS.CUSTOMER$\_$ID$.$