user: ### NOW ANSWER:
Question: What was the water depth in the Gulf of Mexico named Discoverer Clear Leader?
Columns: ['Name', 'Type', 'Entered service', 'Water depth', 'Location', 'Customer']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Cajun Express', 'semi', '2001', 'ft (m)', 'Brazil', 'Petrobras']
SQL:

assistant: SELECT "Water depth" FROM "Table" WHERE "Location" = 'Gulf of Mexico' AND "Name" = 'Discoverer Clear Leader';