How about the names of all artists that prefer the genre tagore?
SELECT artist_name FROM artist  WHERE preferred_genre  =  "tagore"
names of all artists that prefer a specific genre refers to SELECT artist_name FROM artist WHERE preferred_genre = <specific_genre>;