What was the water depth in the Gulf of Mexico named Discoverer Clear Leader?
CREATE TABLE table_name_87 (
    water_depth VARCHAR,
    location VARCHAR,
    name VARCHAR
)
SELECT water_depth FROM table_name_87 WHERE location = "gulf of mexico" AND name = "discoverer clear leader"
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 was the water depth in the Gulf of Mexico named Discoverer Clear Leader? ### Input: CREATE TABLE table_name_87 (
    water_depth VARCHAR,
    location VARCHAR,
    name VARCHAR
) ### Response: SELECT water_depth FROM table_name_87 WHERE location = "gulf of mexico" AND name = "discoverer clear leader"