what is the length (miles) when the name is l-56g?
CREATE TABLE table_name_19 (length__miles_ INTEGER, name VARCHAR)
SELECT MAX(length__miles_) FROM table_name_19 WHERE name = "l-56g"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_19 (length__miles_ INTEGER, name VARCHAR) Question: what is the length (miles) when the name is l-56g? [/INST] SELECT MAX(length__miles_) FROM table_name_19 WHERE name = "l-56g" </s>