Question

Write three UPDATE statements to make the following changes:
Change the title from 'One' to 'With Or Without You'.
Change the artist from 'The Righteous Brothers' to 'Aritha Franklin'.
Change the release years of all songs after 1990 to 2021.
Run your solution and verify the songs in the result table reflect the changes above.
CREATE TABLE song (
song_id INT,
title VARCHAR(60),
artist VARCHAR(60),
release_year INT,
PRIMARY KEY (song_id)
);
INSERT INTO song VALUES
(100, 'Blinding Lights', 'The Weeknd', 2019),
(200, 'One', 'U2', 1991),
(300, 'You\'ve Lost That Lovin\' Feeling', 'The Righteous Brothers', 1964),
(400, 'Johnny B. Goode', 'Chuck Berry', 1958);
-- Write your UPDATE statements here:
SELECT *
FROM song;

Answer 1

UPDATE Song

SET ReleaseYear = 2021

WHERE ReleaseYear >= 1990

What is a result table?

A table known as a result table is always used to hold the data that a SQL operation retrieves. A result table has rows and columns, much like the tables from which you obtain the data. This data is fetched by a computer one row at a time. Typically, the dependent variable is placed in the rows and the independent variable in the columns. The goal of the Results section is to convey your important findings objectively, without bias, and in a logical order utilizing both text and graphical materials (Tables and Figures).

To know more about result table, visit

https://brainly.com/question/27590951

#SPJ4