What are the names of the artists from Bangladesh?
select artist_name from artist where country = "Bangladesh"
Which artists from Bangladesh have never received a rating higher that 7?
select distinct artist_name from artist where country = "Bangladesh" except select distinct artist_name from song where rating > 7
Can you add their genders into the table please?
select artist_name, gender from artist where artist_name in ( select distinct artist_name from artist where country = "Bangladesh" except select distinct artist_name from song where rating > 7 )
What are their preferred genres?
select preferred_genre from artist where artist_name in ( select distinct artist_name from artist where country = "Bangladesh" except select distinct artist_name from song where rating > 7 )
What are the names of the songs they have sung?
select song_name from song where artist_name in ( select distinct artist_name from artist where country = "Bangladesh" except select distinct artist_name from song where rating > 7 )