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)
SELECT song_name FROM song WHERE rating < (SELECT MAX(rating) FROM song WHERE genre_is = "blues")
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE song (song_name VARCHAR, rating INTEGER, genre_is VARCHAR) Question: What are the names of all songs that have a lower rating than some song of blues genre? [/INST] SELECT song_name FROM song WHERE rating < (SELECT MAX(rating) FROM song WHERE genre_is = "blues") </s>