What are the names of all songs that have a lower rating than some song of blues genre?
CREATE TABLE song (song_name VARCHAR, rating INTEGER, genre_is VARCHAR)
[SQL] SELECT song_name FROM song WHERE rating < (SELECT MAX(rating) FROM song WHERE genre_is = "blues") [/SQL]