Write a SELECT statement that joins three tables together using LEFT JOINs. Do not use

NATURAL JOIN. First LEFT JOIN the OE$.$CUSTOMERS table to the OE$.$ORDERS table, and

then LEFT JOIN the OE$.$ORDERS table to the OE$.$ORDER$\_$ITEMS table.

Refer to the ERD that you created in Week $1$ to determine what fields you will need to

use to join the tables together.

Project the following fields: CUST$\_$LAST$\_$NAME, CUST$\_$EMAIL, ORDER$\_$ID$,$ PRODUCT$\_$ID$,$

QUANTITY. Sort the results by ORDER$\_$ID in ascending order