Based on the Code Above,list the Number,name,and Available Credit for All

question 57

Multiple Choice

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

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

---

Definitions:

Top Executives

Senior-level managers who are responsible for directing the operations and formulating policies of an organization.

Productivity

The efficiency at which individuals, companies, or industries produce goods or services, usually measured in terms of output per unit of input.

Competitive Advantage

The attribute(s) or condition(s) that enables a company to outperform its competitors, such as cost structure, product quality, brand, or customer service.

Productivity Obstacles

Factors or conditions that hinder the efficiency or effectiveness of work, leading to reduced output or performance.