- Use A Query To Compute The Average Purchase Value Per Unit Made By Each Customer The Output Should Also Show The Custom 1 (623.91 KiB) Viewed 24 times
by each customer. The output should also show the customers with no
purchase.
CUSTOMER INVOICE LINE PK INV NUMBER 主 contains TAPK PK,FK1 INV NUMBER LINE NUMBER PK CUS CODE HE generates CUS_LNAME CUS_FNAME CUS_INITIAL CUS AREACODE CUS_PHONE CUS_BALANCE FK1 CUS_CODE INV_DATE FK2 P_CODE LINE_UNITS LINE_PRICE is found in PRODUCT VENDOR PK V_CODE PK P CODE V_NAME V_CONTACT HE .- supplies V_AREACODE V_PHONE V_STATE V_ORDER P_DESCRIPT P_INDATE P_QOH P_MIN P_PRICE P_DISCOUNT FK1 V_CODE Cengage Learning © 2015