Based on the Code Shown, Which Query Lists the Number

question 34

Multiple Choice

Based on the code shown, which query lists the number, name, credit limit, and balance for all customers with credit limits that exceed their balances???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

• 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:

Average Total Cost

The complete expenditure of manufacturing (incorporating steady and fluctuating expenses) divided by the aggregate volume of goods produced.

Output

The total quantity of goods or services produced by a company, sector, or economy within a given period.

Revenues

The total income generated by a business or an economy from its operational activities, such as the sale of goods or services before any expenses are deducted.

Costs

Costs refer to the expenses incurred in the production of goods or services, including materials, labor, and overhead.