Table: cajun_express
Columns: name
type
entered_service
water_depth
location
customer

Question: What is the name of the location and ship type in the Gulf of Mexico that entered service in 1999?
SQL: SELECT "name" FROM cajun_express WHERE "location" = 'gulf of mexico' AND "type" = 'ship' AND "entered_service" = '1999'

Question: What was the water depth that entered service in 2001 named Cajun Express?
SQL: SELECT "water_depth" FROM cajun_express WHERE "entered_service" = '2001' AND "name" = 'cajun express'

Question: What was the water depth in the Gulf of Mexico named Discoverer Clear Leader?
SQL: SELECT "water_depth" FROM cajun_express WHERE "location" = 'gulf of mexico' AND "name" = 'discoverer clear leader'

Question: What is the name of a location in Nigeria?
SQL: SELECT "name" FROM cajun_express WHERE "location" = 'nigeria'

Question: What location entered service in 1999 and had a customer of Anadarko?
SQL: SELECT "location" FROM cajun_express WHERE "entered_service" = '1999' AND "customer" = 'anadarko'