Need Help ?

Home / Expert Answers / Other / participation-activity-4-8-2-select-songs-with-null-values-the-given-sql-creates-a-song-table-and-in

(Answered): PARTICIPATION ACTIVITY 4.8.2: Select songs with NULL values. The given SQL creates a Song table and ...



PARTICIPATION ACTIVITY 4.8.2: Select songs with NULL values. The given SQL creates a Song table and inserts some songs. The S

PARTICIPATION ACTIVITY 4.8.2: Select songs with NULL values. The given SQL creates a Song table and inserts some songs. The SELECT statement selects all songs. Modify the SELECT statement to select only songs that have a NULL Title or NULL Artist. Run your solution and verify only the songs with IDs 100, 300, 500, and 600 appear in the result table. 1 CREATE TABLE Song 2 ID INT, 3 Title VARCHAR(60), 4 Artist VARCHAR(60), 5 Release Year INT, 6 PRIMARY KEY (ID) 7); 8 9 INSERT IGNORE INTO Song VALUES 10 (100, "Hey Jude', NULL, 1968), 11 (200, 'When Doves Cry', 'Prince', 1997), 12 (300, NULL, 'The Righteous Brothers', 1964), 13 (400, Johnny B. Goode', 'Chuck Berry', 1958), 14 (500, 'Smells Like Teen Spirit', NULL, 1991), 15 (600, NULL, 'Aretha Franklin', 1967); 16 17 -- Modify the SELECT statement 18 SELECT * 19 FROM Song; Run Reset code Feedback?


We have an Answer from Expert

View Expert Answer

Expert Answer


Answer to PARTICIPATION ACTIVITY 4.8.2: Select songs with NULL values. The given SQL creates a Song table and inserts some songs. ...

The Problem has Answer!

We have detailed solutions for you for more understanding.

View Answer