For this question, use the PostgreSQL database for this course.

Suppose you created the following table:

CREATE TABLE volunteer$($

volunteer$\_$id SERIAL PRIMARY KEY,

first$\_$name VARCHAR NOT NULL,

last$\_$name VARCHAR NOT NULL,

phone VARCHAR

$)$;

Given this new table, which INSERT statement would query from the customer table to insert the first names, last names, and phone numbers of all customers in the right columns and then display the contents of the volunteer table?

LAUNCH DATABASE

a$.)$

INSERT INTO volunteer $($first$\_$name, last$\_$name, phone$)$

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

FROM customer;

b$.)$

INSERT INTO volunteer $($first$\_$name, last$\_$name, phone$)$

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

FROM customer

RETURNING $*$;

c$.)$

INSERT INTO volunteer $($volunteer$\_$id$,$ first$\_$name, last$\_$name, phone$)$

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

FROM customer;

d$.)$

INSERT INTO volunteer

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

FROM customer

RETURNING $*$;