ORDERS CUSTOMERS |Order Customer@ Orderdate Shipdate Shipstreet Shipcity Shipstate Shlipzip Shipcost Customer# astname Firstname Email Address BOOKAUTHOR AUTHOR Sta Zip Referred BOOKS SeN Author Lname Fname ISBN AuthorlD ORDERITEMS Title Region Order? tem ISBN Quantity Pubdate PubID Cost Retail Discount Category Paideach PUBLISHER PubID PROMOTION Contact Problem Description: Bookstore owner needs to know each customer's latest (or most recent) order date along with total dollar amount of purchases by each customer Write and run an SQL SELECT statement to display customer#, customer first name, customer last name, most recent order date, and total dollar amount of purchases by each customer. Display the output in descending order of dollar amount of purchases Please make sure that your screenshot displays complete statement, its complete output, and your account email. Also ensure that column headings look like those shown in the screenshot below RACLE, Live SQL O Feedback Help 2 ashraf SQL Worksheet Clear View Session ?Reset Save Run O Customer# FirstName Last Name Last Order 0n Total Purchased in $ 1007 1010 1020 1001 1003 TAMMY JAKE KENNETH FALAH BONITA LEILA 04-APR-09 03-APR-09 04-APR-89 MORALES 05-APR-09 04-APR-09 379.85 202.85 190.85 182.75 139.95 GIANA LUCAS SMITH ? 1017 BECCA NELSON 03-APR-09 116.4