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

Question

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

Quizplus · Accepted Answer

Option B is correct because it uses the correct syntax for inserting data into a table (FAVORITES) from another table (CANDY) based on a condition (RATING > 7). This is achieved by combining the INSERT INTO and SELECT statements.

James Has Created a New MySQL Table Called FAVORITES and Would