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');

Understand the mechanisms of self-incompatibility and their importance in preventing self-fertilization.

Understand the structure and function of components within the carpel.

Describe the process and significance of double fertilization.

Identify and explain the ploidy levels of different cells in flowering plants.

---

Definitions:

Retirement Savings

Funds that an individual sets aside to use during their retirement years, usually accumulated through retirement accounts.

Monthly Deposits

Regular amounts of money placed into a financial account, investment, or savings plan on a monthly basis, contributing to capital growth or interest earnings.

Retirement Account

A financial account that offers tax benefits for saving for retirement.

Monthly Rate

The interest rate or return expressed on a monthly basis, often used in loan repayments or savings calculations.