Based on the Code Shown, Which Query Lists the Number

question 65

Multiple Choice

Based on the code shown, which query lists the number, name, and balance of all customers with balances greater than or equal to $2,000 and less than or equal to $5,000???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

• A) SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;
• B) SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance > 2000 ;
• C) SELECT CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;
• D) SELECT CustomerNum, CustomerName FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;

---

Definitions:

Credit Terms

The conditions under which a seller will extend credit to a buyer, including the repayment period, interest rate, and the amount of payment.

Net 20

A payment term indicating that the full payment is due within 20 days from the invoice date.

2/10

A common trade credit term indicating a 2% discount if payment is made within 10 days; otherwise, the full amount is due in 30 days.

Net 30 Day Credit

A payment term indicating that the full payment is due within 30 days from the invoice date.