1

a. modify the SQL code to insert a table alias C, replace the full table name prefix with this alias name,

SELECT CUSTOMERS.* FROM ((CUSTOMERS INNER JOIN INVOICES ON CUSTOMERS.CUS_CODE = INVOICES.CUS_CODE) INNER JOIN INVTOTALS ON INVOICES.INV_NUMBER = INVTOTALS.INV_NUMBER) INNER JOIN PAYMENTS ON CUSTOMERS.CUS_CODE = PAYMENTS.CUS_CODE, (LINES INNER JOIN PRODUCTS ON LINES.P_CODE = PRODUCTS.P_CODE) INNER JOIN VENDORS ON PRODUCTS.V_CODE = VENDORS.V_CODE;

b. then provide a code alias name for all of the columns to drop the CUS_ prefix and using upper-lower case.