What is the CHI (Carvill Hurricane Index) when the NHC advisory number is equal to 49b?
CREATE TABLE table_15416002_1 (chi VARCHAR, nhc_advisory_number VARCHAR)
SELECT chi FROM table_15416002_1 WHERE nhc_advisory_number = "49B"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_15416002_1 (chi VARCHAR, nhc_advisory_number VARCHAR) Question: What is the CHI (Carvill Hurricane Index) when the NHC advisory number is equal to 49b? [/INST] SELECT chi FROM table_15416002_1 WHERE nhc_advisory_number = "49B" </s>