The given SQL creates a Song table and inserts some songs. The first SELECT statement selects...

  

Transcribed Image Text:

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. 6 7 8); 9 10 INSERT INTO Song VALUES 11 (100, 'Hey Jude', 'Beatles', 1968, 'pop rock'), 12 (200, 'You Belong With Me', 'Taylor Swift', 2008, "country pop'), 13 (300, 'You\'re still the One', 'Shania Twain', 1998, 'country pop'), (400, 'Need You Now', 'Lady Antebellum', 2011, 'country pop'), (500, 'You\'ve Lost That Lovin\' Feeling', 'The Righteous Brot ers', 1964, 'R&B'), (600, 'That\'s The Way Love Goes', 'Janet Jackson', 1993, 'R&B'), 14 15 16 ReleaseYear INT, Genre VARCHAR(20), PRIMARY KEY (ID) 17 18 19 (700, 'Smells Like Teen Spirit', 'Nirvana', 1991, 'grunge'), (800, 'Even Flow', 'Pearl Jam', 1992, 'grunge'), (900, 'Black Hole Sun', 'Soundgarden', 1994, 'grunge'); 20 21 SELECT * 22 FROM Song 23 WHERE ReleaseYear 1992 24 ORDER BY Release Year; 25 26 SELECT ReleaseYear 27 FROM Song 28 WHERE ID = 800; 29 Chrome File Edit View History Bookmarks Profiles Tab Window Help Facebook Stu 000 Res Google Translate Mail www Peo learn.zybooks.com/zybook/PSULehighValleyIST210Robles Spring 2023/chapter/3/section/6 Network Peo W =zyBooks My library > IST 210: Organization of Data home > 3.6: Subqueries iCloud a Amazon.com: unlo... Peo Sigr | Mail PARTICIPATION 3.6.2: Select songs with subquery. ACTIVITY 1 CREATE TABLE Song ( 2 ID INT, STENT 3 5 6 Bookmarks 8 ); 9 (34 zy: x G Add G Use G To a 12 13 14 15 16 17 18 19 20 Title VARCHAR(60), Artist VARCHAR(60), ReleaseYear INT, Genre VARCHAR(20), PRIMARY KEY (ID) 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. 10 INSERT INTO Song VALUES 11 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. B The JAN 30 (600, 'That\'s The Way Love Goes', 'Janet Jackson', 1993, 'R&B'), (700, 'Smells Like Teen Spirit', 'Nirvana', 1991, 'grunge'), (800, 'Even Flow', 'Pearl Jam', 1992, 'grunge'), (900, 'Black Hole Sun', 'Soundgarden', 1994, 'grunge'); 21 SELECT * 22 FROM Song 23 WHERE ReleaseYear > 1992 24 ORDER BY ReleaseYear; 25 Cou (100, 'Hey Jude', 'Beatles', 1968, 'pop rock'), (200, 'You Belong With Me', 'Taylor Swift', 2008, 'country pop'), (300, 'You\'re Still the One', 'Shania Twain', 1998, 'country pop'), (400, 'Need You Now', 'Lady Antebellum', 2011, 'country pop'), (500, 'You\'ve Lost That Lovin\' Feeling', 'The Righteous Brothers', 1964, tv 10 о 2.6. 2 W³ SQL Wh 'R&B'), Para A อ Cay ABC Fre Feedback? + S a O EzyBooks catalog ZIP Ⓒ 100% (33G Wri G Wri G doe (C. DOCX (A) http | + 80 DOCX Other Bookmarks ? Help/FAQ alex Saavedra Mon Jan 30 9:06 PM Documents Research-Paper final ver...(1).docx 1977497 DOCX Research Paper Template.docx music_basic_data set (1).csv TreeDataCleaned. CSV 3 moviesB (1) SIT ata 10% VERSITY addition Ist 240 Class 2 Chrome File Edit View History Bookmarks Profiles Tab Window Help Facebook Stu 000 Res Google Translate Mail www Peo learn.zybooks.com/zybook/PSULehighValleyIST210Robles Spring 2023/chapter/3/section/6 Network Peo W =zyBooks My library > IST 210: Organization of Data home > 3.6: Subqueries Peo Sigr | Mail iCloud a Amazon.com: unlo... ULO JLLLVI State 1234567 1 CREATE TABLE Song ( ID INT, Title VARCHAR(60), Artist VARCHAR(60), ReleaseYear INT, Genre VARCHAR(20), PRIMARY KEY (ID) (34 zy: x G Add G Use G To a Bookmarks bereets the release year for song with 10 000. 8); 9 10 INSERT INTO Song VALUES 11 12 13 14 15 16 17 18 19 20 21 SELECT * 22 FROM Song 800; JAN 30 (100, 'Hey Jude', 'Beatles', 1968, 'pop rock'), (200, 'You Belong With Me', 'Taylor Swift', 2008, 'country pop'), (300, 'You\'re Still the One', 'Shania Twain', 1998, 'country pop'), 23 WHERE ReleaseYear > 1992 24 ORDER BY ReleaseYear; 25 26 SELECT Release Year 27 FROM Song 28 WHERE ID = 29 30 31 32 Run Reset code Write your SELECT statement here: B The 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. (400, 'Need You Now', 'Lady Antebellum', 2011, 'country pop'), (500, 'You\'ve Lost That Lovin\' Feeling', 'The Righteous Brothers', 1964, 'R&B'), (600, 'That\'s The Way Love Goes', 'Janet Jackson', 1993, 'R&B'), (700, 'Smells Like Teen Spirit', 'Nirvana', 1991, 'grunge'), (800, 'Even Flow', 'Pearl Jam', 1992, 'grunge'), (900, 'Black Hole Sun', 'Soundgarden', 1994, 'grunge'); Cou tv O 10 2.6. 2 W³ SQL Wh A Para อ ABC Cay Fre + S a O ZIP EzyBooks catalog Ⓒ 100% (33G Wri G Wri G doe (C. DOCX (A) http | + 80 DOCX Other Bookmarks ? Help/FAQ alex Saavedra Mon Jan 30 9:06 PM Documents Research-Paper final ver...(1).docx 197747 DOCX Research Paper Template.docx ehmm.... music_basic_data set (1).csv 3 TreeDataCleaned. CSV moviesB (1) SIT ata 10% VERSITY addition Ist 240 Class 2 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. 6 7 8); 9 10 INSERT INTO Song VALUES 11 (100, 'Hey Jude', 'Beatles', 1968, 'pop rock'), 12 (200, 'You Belong With Me', 'Taylor Swift', 2008, "country pop'), 13 (300, 'You\'re still the One', 'Shania Twain', 1998, 'country pop'), (400, 'Need You Now', 'Lady Antebellum', 2011, 'country pop'), (500, 'You\'ve Lost That Lovin\' Feeling', 'The Righteous Brot ers', 1964, 'R&B'), (600, 'That\'s The Way Love Goes', 'Janet Jackson', 1993, 'R&B'), 14 15 16 ReleaseYear INT, Genre VARCHAR(20), PRIMARY KEY (ID) 17 18 19 (700, 'Smells Like Teen Spirit', 'Nirvana', 1991, 'grunge'), (800, 'Even Flow', 'Pearl Jam', 1992, 'grunge'), (900, 'Black Hole Sun', 'Soundgarden', 1994, 'grunge'); 20 21 SELECT * 22 FROM Song 23 WHERE ReleaseYear 1992 24 ORDER BY Release Year; 25 26 SELECT ReleaseYear 27 FROM Song 28 WHERE ID = 800; 29 Chrome File Edit View History Bookmarks Profiles Tab Window Help Facebook Stu 000 Res Google Translate Mail www Peo learn.zybooks.com/zybook/PSULehighValleyIST210Robles Spring 2023/chapter/3/section/6 Network Peo W =zyBooks My library > IST 210: Organization of Data home > 3.6: Subqueries iCloud a Amazon.com: unlo... Peo Sigr | Mail PARTICIPATION 3.6.2: Select songs with subquery. ACTIVITY 1 CREATE TABLE Song ( 2 ID INT, STENT 3 5 6 Bookmarks 8 ); 9 (34 zy: x G Add G Use G To a 12 13 14 15 16 17 18 19 20 Title VARCHAR(60), Artist VARCHAR(60), ReleaseYear INT, Genre VARCHAR(20), PRIMARY KEY (ID) 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. 10 INSERT INTO Song VALUES 11 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. B The JAN 30 (600, 'That\'s The Way Love Goes', 'Janet Jackson', 1993, 'R&B'), (700, 'Smells Like Teen Spirit', 'Nirvana', 1991, 'grunge'), (800, 'Even Flow', 'Pearl Jam', 1992, 'grunge'), (900, 'Black Hole Sun', 'Soundgarden', 1994, 'grunge'); 21 SELECT * 22 FROM Song 23 WHERE ReleaseYear > 1992 24 ORDER BY ReleaseYear; 25 Cou (100, 'Hey Jude', 'Beatles', 1968, 'pop rock'), (200, 'You Belong With Me', 'Taylor Swift', 2008, 'country pop'), (300, 'You\'re Still the One', 'Shania Twain', 1998, 'country pop'), (400, 'Need You Now', 'Lady Antebellum', 2011, 'country pop'), (500, 'You\'ve Lost That Lovin\' Feeling', 'The Righteous Brothers', 1964, tv 10 о 2.6. 2 W³ SQL Wh 'R&B'), Para A อ Cay ABC Fre Feedback? + S a O EzyBooks catalog ZIP Ⓒ 100% (33G Wri G Wri G doe (C. DOCX (A) http | + 80 DOCX Other Bookmarks ? Help/FAQ alex Saavedra Mon Jan 30 9:06 PM Documents Research-Paper final ver...(1).docx 1977497 DOCX Research Paper Template.docx music_basic_data set (1).csv TreeDataCleaned. CSV 3 moviesB (1) SIT ata 10% VERSITY addition Ist 240 Class 2 Chrome File Edit View History Bookmarks Profiles Tab Window Help Facebook Stu 000 Res Google Translate Mail www Peo learn.zybooks.com/zybook/PSULehighValleyIST210Robles Spring 2023/chapter/3/section/6 Network Peo W =zyBooks My library > IST 210: Organization of Data home > 3.6: Subqueries Peo Sigr | Mail iCloud a Amazon.com: unlo... ULO JLLLVI State 1234567 1 CREATE TABLE Song ( ID INT, Title VARCHAR(60), Artist VARCHAR(60), ReleaseYear INT, Genre VARCHAR(20), PRIMARY KEY (ID) (34 zy: x G Add G Use G To a Bookmarks bereets the release year for song with 10 000. 8); 9 10 INSERT INTO Song VALUES 11 12 13 14 15 16 17 18 19 20 21 SELECT * 22 FROM Song 800; JAN 30 (100, 'Hey Jude', 'Beatles', 1968, 'pop rock'), (200, 'You Belong With Me', 'Taylor Swift', 2008, 'country pop'), (300, 'You\'re Still the One', 'Shania Twain', 1998, 'country pop'), 23 WHERE ReleaseYear > 1992 24 ORDER BY ReleaseYear; 25 26 SELECT Release Year 27 FROM Song 28 WHERE ID = 29 30 31 32 Run Reset code Write your SELECT statement here: B The 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. (400, 'Need You Now', 'Lady Antebellum', 2011, 'country pop'), (500, 'You\'ve Lost That Lovin\' Feeling', 'The Righteous Brothers', 1964, 'R&B'), (600, 'That\'s The Way Love Goes', 'Janet Jackson', 1993, 'R&B'), (700, 'Smells Like Teen Spirit', 'Nirvana', 1991, 'grunge'), (800, 'Even Flow', 'Pearl Jam', 1992, 'grunge'), (900, 'Black Hole Sun', 'Soundgarden', 1994, 'grunge'); Cou tv O 10 2.6. 2 W³ SQL Wh A Para อ ABC Cay Fre + S a O ZIP EzyBooks catalog Ⓒ 100% (33G Wri G Wri G doe (C. DOCX (A) http | + 80 DOCX Other Bookmarks ? Help/FAQ alex Saavedra Mon Jan 30 9:06 PM Documents Research-Paper final ver...(1).docx 197747 DOCX Research Paper Template.docx ehmm.... music_basic_data set (1).csv 3 TreeDataCleaned. CSV moviesB (1) SIT ata 10% VERSITY addition Ist 240 Class 2

Answer rating: 100% (QA)

To combine the two existing queries into a single query where the fir... View the full answer