× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
r
4
New Topic  
djnurs1 djnurs1
wrote...
Posts: 628
Rep: 0 0
6 years ago
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 ;
Read 26 times
1 Reply

Related Topics

Replies
wrote...
6 years ago
d
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1147 People Browsing
 105 Signed Up Today
Related Images
  
 1242
  
 316
  
 38