what is the lifespan when the imperial height is 7ft 8 in and the nationality is fiji?
CREATE TABLE table_name_56 (lifespan VARCHAR, imperial VARCHAR, nationality VARCHAR)
SELECT lifespan FROM table_name_56 WHERE imperial = "7ft 8 in" AND nationality = "fiji"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_56 (lifespan VARCHAR, imperial VARCHAR, nationality VARCHAR) Question: what is the lifespan when the imperial height is 7ft 8 in and the nationality is fiji? [/INST] SELECT lifespan FROM table_name_56 WHERE imperial = "7ft 8 in" AND nationality = "fiji" </s>