Given this new table, which INSERT statement would query from the employee table to insert the first name, last name, and email address of all employees in the right columns?

a$.)$

INSERT INTO league $($league$\_$id$,$ first$\_$name, last$\_$name, email$)$

SELECT first$\_$name, last$\_$name, email FROM employee;

b$.)$

INSERT INTO league $($email$,$ last$\_$name, first$\_$name$)$

SELECT first$\_$name, last$\_$name, email FROM employee;

c$.)$

INSERT INTO league $($first$\_$name, last$\_$name, email$)$

SELECT first$\_$name, last$\_$name, email FROM employee;

d$.)$

INSERT INTO league

SELECT first$\_$name, last$\_$name, email FROM employee;