More Advanced SQL - Karaoke Song Selector

Hi Paul,

Just in case you don't see my other comment: It looks like the issue is caused by line 29 in your code, which is selecting all of the properties and not just the title. If you remove this line, I believe your code should work and allow you to proceed to the next step.

Due to how the challenge checks over your code, it's best to avoid adding anything extra that is not specified by the challenge instructions, as this can lead to unexpected error messages that may block you from proceeding.

I hope this helps! Please let me know if there's anything else I can do for you!

Thank you 

Line was 29 was based on Task 1 so the wording on Task 2 should have included creating an edit to Task 1.

I appreciate the clarification and assistance

Thank you 

Just clarification for others having issues with the Karaoke Song Selector Challenge:

There are three steps in this challenge.  At the end, you should have three SELECT statements.

In Step 1, we are asked

For the first step, select all the song titles.

We are not asked to select all of the fields in the table.

In Step 2, we need a second SELECT statement, not an edit of the first statement.

Step 2 and Step 3 are checking our knowledge of the OR and AND operators.  There should be a separate SELECT statement for Step 3.

CREATE TABLE songs (
    id INTEGER PRIMARY KEY,
    title TEXT,
    artist TEXT,
    mood TEXT,
    duration INTEGER,
    released INTEGER);
    
INSERT INTO songs (title, artist, mood, duration, released)
    VALUES ("Bohemian Rhapsody", "Queen", "epic", 60, 1975);
INSERT INTO songs (title, artist, mood, duration, released)
    VALUES ("Let it go", "Idina Menzel", "epic", 227, 2013);
INSERT INTO songs (title, artist, mood, duration, released)
    VALUES ("I will survive", "Gloria Gaynor", "epic", 198, 1978);
INSERT INTO songs (title, artist, mood, duration, released)
    VALUES ("Twist and Shout", "The Beatles", "happy", 152, 1963);
INSERT INTO songs (title, artist, mood, duration, released)
    VALUES ("La Bamba", "Ritchie Valens", "happy", 166, 1958);
INSERT INTO songs (title, artist, mood, duration, released)
    VALUES ("I will always love you", "Whitney Houston", "epic", 273, 1992);
INSERT INTO songs (title, artist, mood, duration, released)
    VALUES ("Sweet Caroline", "Neil Diamond", "happy", 201, 1969);
INSERT INTO songs (title, artist, mood, duration, released)
    VALUES ("Call me maybe", "Carly Rae Jepsen", "happy", 193, 2011);
SELECT title FROM songs;
SELECT title FROM songs WHERE mood="epic"