need a SQL query that can do the following

Saleco hardware store sales manager wants to know how many total items each customer purchased on the most recent invoice date. Write and run an SQL statement to display the following information. The example screenshot below

Also, please notice that column headings/captions, which are different from column names and the output is sorted in descending order of total items purchased.

CUSTOMER INVOICE INV NUMBER CUS CODIE INV DATE CUS_CODE CUS LNAME CUS FNAME CUS INITIAL CUS AREACODE CUS PHONE CUS BALANCE 1NV-NUMBER LINE NUMBER P CODE LINE UNITS LINE PRICE PRODUCT P CODE P DESCRIPT P INDATE P.QOH P MIN P PRICE P DISCOUNT VENDOR V CODE V NAME V CONTACT V AREACODE V PHONE V STATE V ORDER