× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
I
3
p
2
w
2
y
2
J
2
Q
2
r
2
o
2
e
2
j
2
d
2
T
2
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 upon the contents of the ORDERS table, which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323?
 a. SELECT order, SUBSTR(shipzip, 1, 323)FROM orders;
  b. SELECT order, SUBSTR(shipzip, 1, 323)FROM ordersWHERE shipzip = 323;
  c. SELECT orderFROM ordersWHERE shipzip = SUBSTR(shipzip, 1, 323);
  d. SELECT orderFROM ordersWHERE SUBSTR(shipzip, 1, 3) = 323;
Read 70 times
2 Replies
Replies
Answer verified by a subject expert
Studyboy45Studyboy45
wrote...
#1
Top Poster
Posts: 933
Rep: 4 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
TY
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1641 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Related Images
  
 325
  
 139
  
 138
Your Opinion
What's your favorite math subject?
Votes: 559
Previous poll results: Who will win the 2024 president election?