× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
5
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
NorrisBBQ NorrisBBQ
wrote...
Go to Answer
Posts: 634
Rep: 0 0
6 years ago
Based on the code above, list the number, name, and balance of all customers with balances greater than or equal to 2,000 and less than or equal to 5,000.
 a. SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;
  b. SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance > 2000 ;
 c. SELECT CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;
 d. SELECT CustomerNum, CustomerName FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;
Read 19 times
2 Replies
Replies
Answer verified by a subject expert
PinkFlowerPinkFlower
wrote...
#1
Top Poster
Posts: 899
Rep: 5 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

NorrisBBQ Author
wrote...
#2
6 years ago
Above and beyond my expectations for this site
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1235 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 888
  
 135
  
 210
Your Opinion
What's your favorite math subject?
Votes: 293
Previous poll results: Does a gender wage gap exist in America?