Page 1 of 1

CUSTOMER INVOICE LINE PK INV NUMBER 主 contains TAPK PK,FK1 INV NUMBER LINE NUMBER PK CUS CODE HE generates CUS_LNAME CUS

Posted: Fri Apr 29, 2022 6:51 am
by answerhappygod
 1
1 (623.91 KiB) Viewed 22 times
What's the SQL Query to this question using the table
above?
Count the number of customers who do not have an invoice. (i.e.
customer who did not make a 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