user: ### NOW ANSWER:
Question: what is the length (miles) when the name is L-56G?
Columns: ['County', 'Name', 'Length (miles)', 'West or south terminus', 'East or north terminus']
Types: ['text', 'text', 'real', 'text', 'text']
Sample row: ['Adams', 'L-1E', 0.21, 'NE 74 east of Ayr', 'U.S. 281 east of Ayr']
SQL:

assistant: SELECT MAX("Length (miles)") FROM "Table" WHERE "Name" = 'L-56G';