SQLite 3.27

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

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);


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);

INSERT INTO Artists (artist_name) VALUES ("Bob");
INSERT INTO Artists (artist_name) VALUES ("Shawn");
INSERT INTO Songs (song_name) VALUES ("one song");
INSERT INTO Songs (song_name) VALUES ("another song");
INSERT INTO song_artist (artist, song) VALUES (1, 1);
INSERT INTO song_artist (artist, song) VALUES (2, 1);
INSERT INTO song_artist (artist, song) VALUES (2, 2);      

INSERT INTO Artists (artist_name) VALUES ("Bobby");
INSERT INTO Songs (song_name) VALUES ("song no 3");
INSERT INTO song_artist (artist, song) VALUES (2, 3);
INSERT INTO song_artist (artist, song) VALUES (3, 3);
INSERT INTO song_artist (artist, song) VALUES (3, 2);

✓
select * from Songs;


song_id
song_name


1
one song

2
another song

3
song no 3


select * from Artists;


artist_id
artist_name


1
Bob

2
Shawn

3
Bobby


select * from Song_Artist;


song
artist


1
1

1
2

2
2

3
2

3
3

2
3


select * from Songs s
where 
exists (select * from Song_Artist sa inner join
   artists a on sa.artist = a.artist_id
   where s.song_id = sa.song and a.artist_Name = 'Shawn')
and   
not exists (select * from Song_Artist sa inner join
   artists a on sa.artist = a.artist_id
   where s.song_id = sa.song and a.artist_Name = 'Bob');    

      


song_id
song_name


2
another song

3
song no 3

`song_id`	`song_name`
`1`	`one song`
`2`	`another song`
`3`	`song no 3`

`artist_id`	`artist_name`
`1`	`Bob`
`2`	`Shawn`
`3`	`Bobby`

`song`	`artist`
`1`	`1`
`1`	`2`
`2`	`2`
`3`	`2`
`3`	`3`
`2`	`3`

`song_id`	`song_name`
`2`	`another song`
`3`	`song no 3`