Question: For this question, use the PostgreSQL database for this course. Which of the following is a correctly formatted INSERT statement that will insert three records

For this question, use the PostgreSQL database for this course.
Which of the following is a correctly formatted INSERT statement that will insert three records into the genre table and return just the name columns inserted values?
LAUNCH DATABASE
a.)
INSERT INTO genre (genre_id, name)
VALUES (30, 'Funk' )
(31, 'Classical')
(32, 'Pop Rock')
RETURNING name;
b.)
INSERT INTO genre (genre_id, name)
VALUES (30, 'Funk' ),
(31, 'Classical', 'Rock'),
(32, 'Pop Rock')
RETURNING name;
c.)
INSERT INTO genre (genre_id, name)
VALUES (30, 'Funk' ),
(31, 'Classical'),
(32, 'Pop Rock')
RETURNING name;
d.)
INSERT INTO genre (genre_id, name)
VALUES (30, 'Funk' ),
(31, 'Classical'),
(32, 'Pop Rock')
RETURNING *;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!