What is the Name of the Player with a Rank of 23 or less, Heat of 4 and Result of 55.91?
CREATE TABLE table_name_84 (name VARCHAR, result VARCHAR, heat VARCHAR, rank VARCHAR)
SELECT name FROM table_name_84 WHERE heat = 4 AND rank < 23 AND result = "55.91"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_84 (name VARCHAR, result VARCHAR, heat VARCHAR, rank VARCHAR) Question: What is the Name of the Player with a Rank of 23 or less, Heat of 4 and Result of 55.91? [/INST] SELECT name FROM table_name_84 WHERE heat = 4 AND rank < 23 AND result = "55.91" </s>