James Has Created a New MySQL Table Called FAVORITES and Would

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