Table: carvill_hurricane_index
Columns: name
year
landfall
nhc_advisory_number
v_mph
r_miles
saffir_simpson_category
chi

Question: What is the maximum number for the Saffir-Simpson category in the Carvill Hurricane Index?
SQL: SELECT MAX("saffir_simpson_category") FROM carvill_hurricane_index

Question: What is the maximum miles per hour recorded when the  CHI (Carvill Hurricane Index) is equal to 13.5
SQL: SELECT MAX("v_mph") FROM carvill_hurricane_index WHERE "chi" = '13.5'

Question: What is the CHI (Carvill Hurricane Index) when the NHC advisory number is equal to 49b?
SQL: SELECT "chi" FROM carvill_hurricane_index WHERE "nhc_advisory_number" = '49B'

Question: What is the maximum number of miles reached in a Texas landfall when the Saffir-Simpson category is smaller than 3.0?
SQL: SELECT MAX("r_miles") FROM carvill_hurricane_index WHERE "landfall" = 'Texas' AND "saffir_simpson_category" < 3.0

Question: What are the miles when the Carvill Hurricane Index (CHI) is equal to 9.9?
SQL: SELECT "r_miles" FROM carvill_hurricane_index WHERE "chi" = '9.9'

Question: What is the Saffir-Simpson category for the hurricane named Bonnie?
SQL: SELECT "saffir_simpson_category" FROM carvill_hurricane_index WHERE "name" = 'Bonnie'