Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following new table: CREATE TABLE volunteer ( volunteer _ id SERIAL PRIMARY KEY, first _ name VARCHAR NOT NULL, last _ name VARCHAR
Consider the following new table:
CREATE TABLE volunteer
volunteerid SERIAL PRIMARY KEY,
firstname VARCHAR NOT NULL,
lastname VARCHAR NOT NULL,
phone VARCHAR
;
Given this new table, which INSERT statement would query from the customer table to insert the first name, last name, and phone number of all customers in the right columns?
a
INSERT INTO volunteer firstname, lastname, phone
SELECT firstname, lastname, phone FROM customer;
b
INSERT INTO volunteer
SELECT firstname, lastname, phone FROM customer;
c
INSERT INTO volunteer phone lastname, firstname
SELECT firstname, lastname, phone FROM customer;
d
INSERT INTO volunteer volunteerid firstname, lastname, phone
SELECT firstname, lastname, phone FROM customer;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started