Based on the Code Shown, Which Query Lists the Number

question 15

Multiple Choice

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

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

Value

A specific piece of data, often numerical, representing the magnitude, quantity, or importance of a variable or parameter in a process or calculation.

Source

The origin from which something comes, such as electricity in an electrical circuit, or data in an information system.

Destination

The term Destination in the context of automation and control systems refers to the target location or variable where data or control signals are directed.

Stored Value

A stored value refers to a quantity or information that is saved or retained in a storage system or medium for future use.