Contents of the BOOKS Table​

question 118

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;