× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
w
3
w
3
e
3
3
r
3
2
b
2
M
2
V
2
f
2
c
2
c
2
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
banoshaher banoshaher
wrote...
Go to Answer
Posts: 648
Rep: 0 0
6 years ago
Which of the following is a valid SQL statement?
 a. SELECT SUM(quantityretail) Total SalesFROM orders JOIN orderitems ON orders.order = orderitems.orderJOIN books ON orderitems ON orderitems.ISBN = books.ISBNWHERE orderdate = '02-APR-03';
  b. SELECT SUM(quantityretail) Total SalesFROM orders JOIN orderitems ON orders.order = orderitems.orderJOIN books ON orderitems ON orderitems.ISBN = books.ISBNHAVING orderdate = '02-APR-03';
  c. SELECT customer, SUM(quantityretail) Total SalesFROM orders JOIN orderitems ON orders.order = orderitems.orderJOIN books ON orderitems ON orderitems.ISBN = books.ISBNHAVING orderdate = '02-APR-03';
  d. SELECT customer, SUM(quantityretail) Total SalesFROM orders JOIN orderitems ON orders.order = orderitems.orderJOIN books ON orderitems ON orderitems.ISBN = books.ISBNHAVING orderdate = '02-APR-03'GROUP BY customer;
Read 45 times
1 Reply
Replies
Answer verified by a subject expert
ashxeveashxeve
wrote...
#1
Top Poster
Posts: 917
Rep: 1 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

banoshaher Author
wrote...

6 years ago
Smart ... Thanks!
mmmm_dat_userna
wrote...

Yesterday
Good timing, thanks!
SupremeDJ
wrote...

2 hours ago
I appreciate what you did here, answered it right Smiling Face with Open Mouth
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1368 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 475
  
 415
  
 195
Your Opinion
Who will win the 2024 president election?
Votes: 119
Closes: November 4
Previous poll results: Does a gender wage gap exist in America?