Problem Description

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 shows only partial output for your homework, please include complete SQL statement, its complete output, and your username - all of these in a single screenshot.

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.

Hint: Purchase information is listed in the Line table.

ashirani db robcor ch08 Please show complete SELECT statement here He0D History Select: All Nonc The following is partial output; your screenshot should show Answer Set , complete output here X Answer Set (1) Please display column headings lik these. (2) Sort the output in descending order of total items purchased Customer First Name Last Name Total Items 10011 Leona Dunne 14 10018 Anne Farriss12 ashirani db robcor ch08 Please show complete SELECT statement here He0D History Select: All Nonc The following is partial output; your screenshot should show Answer Set , complete output here X Answer Set (1) Please display column headings lik these. (2) Sort the output in descending order of total items purchased Customer First Name Last Name Total Items 10011 Leona Dunne 14 10018 Anne Farriss12