What are the names of all the songs that have a lower rating than some song of the blues genre?
select song_name from song where rating < ( select max ( rating ) from song where genre_is = "blues" )
What are the names of all the songs that have a higher rating than some song of the blues genre?
select song_name from song where rating > ( select max ( rating ) from song where genre_is = "blues" )
What are the names and ratings of all songs of the blues genre?
select song_name,rating from song where genre_is = "blues"