SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE IF NOT EXISTS Artists ("artist_id" INTEGER PRIMARY KEY, "artist_name" TEXT);
✓
CREATE TABLE IF NOT EXISTS Songs ("song_id" INTEGER PRIMARY KEY, "song_name" TEXT);
✓
CREATE TABLE IF NOT EXISTS song_artist (
  song INTEGER, 
  artist INTEGER,
  FOREIGN KEY("song") REFERENCES "Songs"("song_id") ON DELETE CASCADE,
  FOREIGN KEY("artist") REFERENCES "Artists"("artist_id") ON DELETE CASCADE
);
✓
INSERT INTO Artists (artist_name) VALUES ("Bob"), ("Shawn");
✓
INSERT INTO Songs (song_name) VALUES ("one song"), ("another song");
✓
INSERT INTO song_artist (artist, song) VALUES (1, 1), (2, 1), (2, 2);
✓
SELECT s.*
FROM Songs s
JOIN song_artist sa ON sa.song = s.song_id
JOIN Artists a ON a.artist_id = sa.artist
WHERE a.artist_name IN ('Shawn', 'Bob')
GROUP BY s.song_id
HAVING SUM(a.artist_name = 'Bob') = 0;


song_id
song_name


2
another song