What is the Diameter (km) of the Valle with a Longitude of 152.5e named before 1997?
CREATE TABLE table_name_52 (
    diameter__km_ INTEGER,
    longitude VARCHAR,
    year_named VARCHAR
)
SELECT MAX(diameter__km_) FROM table_name_52 WHERE longitude = "152.5e" AND year_named < 1997
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the Diameter (km) of the Valle with a Longitude of 152.5e named before 1997? ### Input: CREATE TABLE table_name_52 (
    diameter__km_ INTEGER,
    longitude VARCHAR,
    year_named VARCHAR
) ### Response: SELECT MAX(diameter__km_) FROM table_name_52 WHERE longitude = "152.5e" AND year_named < 1997