(Solved): Problem 17 Use a query to show the invoices and invoice totals in Figure P7.17. Sort the r ...

Problem 17

Use a query to show the invoices and invoice totals in Figure P7.17. Sort the results by customer code and then by invoice number. The query should match the picture above extacly how it is. ^^^

FIGURE P7.9 THE CH07_SALECO DATABASE Relational diagram Table name: CUSTOMER Table name: VFNDOR Tahle name: PRONIICT \begin{tabular}{llc} \hline CUS_CODE & Number of Invoices & Total Customer Purchases \\ \hline 10011 & 3 & \( 444.00 \) \\ \hline 10012 & 1 & \( 153.85 \) \\ \hline 10014 & 2 & \( 422.77 \) \\ \hline 10015 & 1 & \( 34.97 \) \\ \hline 10018 & 1 & \( 70.44 \) \\ \hline \end{tabular}