How about the names of all artists that prefer the genre folk?
SELECT artist_name FROM artist  WHERE preferred_genre  =  "folk"
artists that prefer the genre folk refers to WHERE preferred_genre = 'folk';