Based on the Code Above,list the Number,name,credit Limit,and Balance for All

question 75

Multiple Choice

Based on the code above,list the number,name,credit limit,and balance for all customers with credit limits that exceed their balances.​

• A) ​SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimit>Balance ;
• B) ​SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ;
• C) ​SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE CreditLimit>Balance ;
• D) ​SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer ;

---

Definitions:

Economist

A professional or expert in economics, studying the production, distribution, and consumption of goods and services.

Rate of Return

The gain or loss on an investment over a specified period, expressed as a percentage of the investment’s cost.

Price-taker Market

A market situation where buyers and sellers accept the prevailing market price as they individually have no influence over it.

Short-run Market Supply

The total quantity of a good that producers are willing and able to sell at a given price over a short period.