× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
z
4
n
4
t
4
k
3
x
3
r
3
m
3
j
3
c
3
l
3
e
3
s
2
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
MADUBUCA76 MADUBUCA76
wrote...
Go to Answer
Posts: 620
Rep: 0 0
6 years ago
Based on the contents of the BOOKS table, which of the following SQL statements will return the total profit generated by books provided by publisher 4?
 a. SELECT TOTAL(retail-cost) FROM booksWHERE pubid = 4;
  b. SELECT TOTAL(retail-cost) FROM booksGROUP BY pubid;
  c. SELECT SUM(retail-cost) FROM booksWHERE pubid = 4;
  d. SELECT SUM(retail-cost) FROM booksGROUP BY pubid = 4;
Read 46 times
1 Reply
Replies
Answer verified by a subject expert
mizunoshiromizunoshiro
wrote...
#1
Top Poster
Posts: 1263
Rep: 4 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

MADUBUCA76 Author
wrote...

6 years ago
Thanks for your help!!
Cdfields
wrote...

Yesterday
This calls for a celebration Person Raising Both Hands in Celebration
jbarnett14
wrote...

2 hours ago
This site is awesome
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  509 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 355
  
 430
  
 131
Your Opinion
Do you believe in global warming?
Votes: 488
Previous poll results: Who's your favorite biologist?