Use a query to compute the average purchase value per unit made by each customer. The output should also show the custom
Posted: Fri Apr 29, 2022 6:51 am
- 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 25 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