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 ;
d
You might also like to view...
Identify the situation where indirect channels are more useful than direct channels
A) When product customization is important. B) When after-sale service is important. C) When purchase orders are large. D) When transportation and storage are complex.
The mailbox rule means that:
A) Offers and acceptances must be communicated through the mail in order to be effective. B) A revocation is effective when sent. C) Offers and acceptances are effective when placed in the mail. D) A properly dispatched acceptance is effective even if the offeror never receives it.
Jacob purchases camping equipment at a cost of $3,450 by taking out an 9% add-on installment loan. The loan requires a 10% down payment and equal monthly payments for 2 years. How much are Jacob's monthly payments?
A. $74.89 B. $225.15 C. $152.66 D. $92.44
Zack Peyton borrowed $398,000 from Fifth First Bank to purchase a new home. Zack gave First Bank a mortgage on his home. The mortgage was recorded on January 3, 2014. Zack had made a down payment of $42,000. When Zack moved in, he purchased an in-ground swimming pool from Paddock Pools for $35,000. Zack paid Paddock $4,000 and Paddock financed the remaining amount for him, recording a mortgage
for $29,000 on February 26, 2014. Zack needed window coverings, landscape, and some new furniture. Wells Fargo gave Zack a $150,000 home equity line of credit, secured by a mortgage on Zack's home for $150,000. Wells Fargo recorded the home equity credit line mortgage on February 1, 2014. Zack, because of a bonus at work, did not draw on the line of credit until June 10, 2015, using $25,000. The economy went south somewhere around September 2015. The value of Zack's home dropped by almost 50%. Zack lost his job. He could no longer make his payments. Fifth First Bank served Zack with a notice of foreclosure on November 1, 2015. ?With respect to the mortgage loan from Fifth First Bank: A)?Zack is the mortgagor. B)?Zack is the mortgagee. C)?Fifth First Bank is the mortgagor. D)?None of the above