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 first name (Partial results shown in Figure P7.44).

 

EMP_NUM EMP_LNAME EMP_FNAME ABERNATHY LOURDES 83565 83792 ANDERSEN WALLY TOTALINVOICES 19158.54 20627.47 22098.88 83705 BARR JOSE 84049 BRANDON LANE 20683.06 83936 BRAY BRADFORD 21139.94 84248 CASTLE DANICA 17700.42 84420 CAUDILL DOUG 11308.21 83993 CORTES SANG 17436.88 84021 DICKINSON JAROD 20437.35 84163 EASLEY GWEN 24813.26