Write a query to display the employee number, last name, first name, and sum of invoice totals for all employees who completed an invoice. Sort the output by employee last name and then by firstname.

Transcribed Image Text:

EMP NUMİ EMP LNAME | EMP FNAME | TOTALINVOICES 19158.54 20627.47 22098.88 20683.06 21139.94 17700.42 11308.21 17436.88 20437.35 24813.26 18883.13 23839.85 83565 ABERNATHY LOURDES 83792 ANDERSEN WALLY 83705 BARR 84049 BRANDON LANE 83936 BRAY 84248 CASTLE DANICA 84420 CAUDILL DOUG 83993 CORTES SANG 84021 DICKINSON JAROD 84163 EASLEY 83537 ENGLISHCLEO 84078 ERWN JOSE BRADFORD GWEN DIEGO