Contents of the BOOKS table

-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 books WHERE pubid = 4;
B) SELECT TOTAL(retail-cost)FROM books GROUP BY pubid;
C) SELECT SUM(retail-cost)FROM books WHERE pubid = 4;
D) SELECT SUM(retail-cost)FROM books GROUP BY pubid = 4;

Question

Contents of the BOOKS table​
 
-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 books WHERE pubid = 4; 
B) SELECT TOTAL(retail-cost)FROM books GROUP BY pubid; 
C) ​SELECT SUM(retail-cost)FROM books WHERE pubid = 4; 
D) SELECT SUM(retail-cost)FROM books GROUP BY pubid = 4;​

Quizplus · Accepted Answer

To get the total profit generated by books provided by publisher 4, we need to sum up the difference between retail price and cost for all the books that have pubid 4. This can be achieved by using the SUM function and adding a WHERE clause to filter only the books with pubid 4. Therefore, the correct query is: SELECT SUM(retail-cost) FROM books WHERE pubid = 4. Option A is incorrect because it does not include the SUM function and it does not filter the books by pubid 4. Option B is incorrect because it groups the results by pubid, but we only want to retrieve the total for publisher 4. Option D is incorrect because GROUP BY should not include a conditional statement like "GROUP BY pubid = 4".

Contents of the BOOKS Table​

Contents of the BOOKS Table