CREATE TABLE table_56779 ("County" CLOB, "Name" CLOB, "Length  ( miles ) " FLOAT, "West or south terminus" CLOB, "East or north terminus" CLOB)

what is the length (miles) when the name is l-56g?
SELECT MAX("Length (miles)") FROM table_56779 WHERE "Name" = 'l-56g'
SELECT MAX("Length (miles)") FROM "table_56779" WHERE "Name" = 'l-56g'