ACTIVITY

The given SQL creates a Song table and inserts some songs. The first SELECT statement selects songs released after $1992.$ The second SELECT statement selects the release year for song with ID $800.$

Create a third query that combines the two existing queries. The first SELECT should be the outer query, and the second SELECT should be the subquery. The ORDER BY clause should appear after the subquery.

Run your solution and verify the new query returns a result table with five rows, all with release years after $1992.$

CREATE TABLE Song $($

ID INT,

Title VARCHAR$(60),$

Artist VARCHAR$(60),$

Releaseyear INT,

Genre VARCHAR$(20),$

PRIMARY KEY $($ID$)$

;

INSERT INTO SONG VALUES

$(100,$ 'Hey Jude', 'Beatles', $1968,$ 'pop rock'$),$

$(200,$ 'You Belong with Me$\text{'},$ 'Taylor Swift', $2008,$ 'country pop'$),$

$(300,$ 'Youl're still the One', 'Shania Twain', $1998,$ 'country pop'$),$

$(400,$ 'Need You Now', 'Lady Antebellum', $2011,$ 'country pop'$),$

$(500,$ 'You $\text{'}$ve Lost That Lovin' Feeling', 'The Righteous Brothers', $1964,\text{'}$R&B$\text{'}),$

$(600,$ 'Thatl's The way Love Goes', 'Janet Jackson', $1993,\text{'}$R&B$\text{'}),$

$(700,$ 'Smells Like Teen Spirit', 'Nirvana', $1991,$ 'grunge'$),$

$(800,$ 'Even Flow', 'Pearl Jam', $1992,$ 'grunge'$),$

$(900,$ 'Black Hole Sun', 'Soundgarden', $1994,$ 'grunge' $\text{'})$;

SELECT $*$

FROM SOng

WHERE Releaseyear $>1992$

ORDER BY ReleaseYear;

SELECT Releaseyear

FROM SOng

WHERE ID $=800$;