Lille problem med SQL, angående SELECT
Hej Eksperten jeg er i gang med at lære SQL, Der hvor jeg lærer det får jeg nogle opgaver. Jeg er overbevist om at fejlen er en eller anden, Nåårh ja det er da osse rigtigt fejl :)Her kommer opgaven og koden, håber der er en der har tid til at hjælpe mig :)
Add another SELECT that uses OR to show the titles of the songs that have an 'epic' mood or a release date after 1990.
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);
Det sidste her nede, er min egen kode der ikke virker :(
SELECT*FROM songs WHERE title = "epic" OR released >1990;