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;

---

Definitions:

Floral Bouquets

Arrangements of flowers often used for decorative purposes or given as gifts for special occasions, composed of various types of flowers and foliage.

Activity-based Costing

A costing method that assigns overhead and indirect costs to specific activities, improving the accuracy of product and service pricing.

Idle Capacity

Unused production capability or facilities that could be used to produce more goods but are not currently being utilized due to lack of demand or efficiency.

Plantwide Overhead Rate

A single overhead rate calculated by dividing total manufacturing overhead costs by the total allocation base for the entire plant.