10 Write Query Count Number Customers Balance 500 Q37091627

FIGURE P7.9 THE CH07 SALECO DATABASE Relational diagram CUSTOMER VENDOR INVOICE PK,FK1 FK1 Cus Code Inv Date FK2 P Code Line_

10. Write a query to count the number of customers witha balance of more than $500.

FIGURE P7.9 THE CH07 SALECO DATABASE Relational diagram CUSTOMER VENDOR INVOICE PK,FK1 FK1 Cus Code Inv Date FK2 P Code Line_Units V State Table name: VENDOR Table name: CUSTOMER CUS CODE cus V CONTACT AREACODE V PHONE V STATEV ORDER CUS FNAME CUS 21344 Gomez Bros. Orteg 222-1672 s Ltd Table name: INVOICE Table name: LINE Table name: PRODUCT 11CER31 Power

OR
OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.