Question

The given SQL creates a song table and inserts three songs.

Answer 1

Answer:

• UPDATE song SET title = 'With Or Without You' WHERE song_ID = 200
• UPDATE song SET artist = 'Aritha Franklin' WHERE song_ID = 300
• UPDATE song SET release_year = 2021 WHERE release_year > 1990

Explanation:

Given

The above table definition

Required

Statement to update the table

The syntax of an update statement is:

UPDATE table-name SET column-name = 'value' WHERE column-name = 'value'

Using the above syntax, the right statements is as follows:

• UPDATE song SET title = 'With Or Without You' WHERE song_ID = 200

The above sets the title to 'With Or Without You' where song id is 200

• UPDATE song SET artist = 'Aritha Franklin' WHERE song_ID = 300

The above sets the artist to 'Aritha' where song id is 300

• UPDATE song SET release_year = 2021 WHERE release_year > 1990

The above sets the release year to '2021' for all release year greater than 1990