Bradford Would Like to Write a Query That Returns the Average

question 2

Multiple Choice

Bradford would like to write a query that returns the average unit sales over the last 30 days for each of his bakery's product types: cupcakes, muffins, and cookies. There are several flavors of each in the table, but the product types are identified in a CATEGORY column as "Cupcake," "Muffin," or "Cookie." What should the last part of his query be, following the part shown below? ​
SELECT CATEGORY, AVG(UNIT_SALES) FROM PRODUCTS

• A) ORDER BY CATEGORY;
• B) GROUP BY CATEGORY;
• C) BETWEEN ('Cupcake', 'Muffin', 'Cookie');
• D) WHERE CATEGORY IN ('Cupcake', 'Muffin', 'Cookie');

---

Definitions:

Social Learning Theory

A theory that suggests people learn new behaviors by observing and imitating others, alongside direct reinforcement or punishment.

Symbolizing

The use of symbols or symbolism to represent ideas, concepts, or attributes, often employed in communication, art, and culture to convey deeper meanings.

Self-Control

The ability to regulate one's emotions, thoughts, and behaviors in the face of temptations and impulses.

Across Cultures Competency

The ability to effectively interact, communicate, and work across cultural boundaries.