CREATE TABLE table_name_19 (length__miles_ INT, name VARCHAR)

what is the length (miles) when the name is l-56g?
SELECT MAX(length__miles_) FROM table_name_19 WHERE name = "l-56g"
SELECT MAX("length__miles_") FROM "table_name_19" WHERE "l-56g" = "name"