Suppose you created the following table:

CREATE TABLE league$($

league$\_$id SERIAL PRIMARY KEY,

first$\_$name VARCHAR NOT NULL,

last$\_$name VARCHAR NOT NULL,

email VARCHAR

$)$;

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?

launch database

A$.)$

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

SELECT first$\_$name, last$\_$name, email

FROM employee;

B$.)$

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

SELECT first$\_$name, last$\_$name, email

FROM employee;

C$.)$

INSERT INTO league

SELECT first$\_$name, last$\_$name, email

FROM employee;

D$.)$

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

SELECT last$\_$name, email

FROM employee;