CREATE TABLE locationlist$($

locationlist$\_$id SERIAL PRIMARY KEY,

city VARCHAR NOT NULL,

country VARCHAR NOT NULL,

postal$\_$code VARCHAR

$)$;

Given this new table, which INSERT statement would query from the customer table to insert the city, country, and postal$\_$code of all customers in the right columns?

INSERT INTO locationlist $($postal$\_$code, country, city$)$

SELECT city, country, postal$\_$code FROM customer;

INSERT INTO locationlist $($city$,$ country, postal$\_$code$)$

SELECT city, country, postal$\_$code FROM customer;

INSERT INTO locationlist

SELECT city, country, postal$\_$code FROM customer;

INSERT INTO locationlist $($locationlist$\_$id$,$ city, country, postal$\_$code$)$

SELECT city, country, postal$\_$code FROM customer;