Contents of the BOOKS Table​

Multiple Choice

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;​