Contents of the BOOKS Table​

Multiple Choice

Contents of the BOOKS table​

-Based on the contents of the BOOKS table,which of the following is a valid SQL statement?​

A) ​SELECT pubid,AVERAGE(retail-cost) "Average Profit"
FROM books;
B) SELECT pubid,AVERAGE(retail-cost) "Average Profit"
FROM books
GROUP BY pubid;​
C) ​SELECT pubid,AVG(retail-cost) "Average Profit"
FROM books
GROUP BY pubid;
D) ​SELECT pubid,AVG(retail-cost) "Average Profit"
FROM books
HAVING retail-cost > 25;