Question: Which of the following is a correctly formatted INSERT statement that will insert three records into the genre table and return just the name column

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')
(32, 'Pop Rock')
RETURNING name;
C.)
INSERT INTO genre (genre_id, name)
VALUES (30, 'Funk' ),
(31, 'Classical'),
(32, 'Pop Rock')
RETURNING *;
D.)
INSERT INTO genre (genre_id, name)
VALUES (30, 'Funk' ),
(31, 'Classical', 'Rock'),
(32, 'Pop Rock')
RETURNING name;

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!