Name the award won in the hall of fame
CREATE TABLE table_name_30 (award VARCHAR, result VARCHAR, category VARCHAR)
SELECT award FROM table_name_30 WHERE result = "won" AND category = "hall of fame"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (award VARCHAR, result VARCHAR, category VARCHAR) Question: Name the award won in the hall of fame [/INST] SELECT award FROM table_name_30 WHERE result = "won" AND category = "hall of fame" </s>