James Has Created a New MySQL Table Called FAVORITES and Would

question 10

Multiple Choice

James has created a new MySQL table called FAVORITES and would like to populate it with data from the existing CANDY table. Which command can he use to add data for rows with a rating of seven or more?

• A) SELECT ID, NAME, PRICE, RATING FROM CANDY WHERE (RATING > 7));
• B) INSERT INTO FAVORITES (SELECT ID, NAME, PRICE, RATING FROM CANDY WHERE (RATING > 7));
• C) SELECT ID, NAME, PRICE, RATING FROM CANDY WHERE (RATING > 7)) INSERT INTO FAVORITES;
• D) INSERT INTO FAVORITES (FROM CANDY IF RATING > 7);

---

Definitions:

Conference Board of Canada

An independent, not-for-profit research organization that specializes in economic trends, organizational performance, and public policy issues in Canada.

Financial Contributions

The act of providing monetary resources to support a project, individual, organization, or cause.

Canada Pension Plan

A governmental social insurance program in Canada that provides retirement, disability benefits, and survivor benefits.

Workers' Compensation Insurance

Insurance that businesses carry to cover medical costs and lost wages for employees who get injured or sick on the job.