Table: dampier_bunbury_pipeline_2
Columns: name_year_commissioned
owner_operator
length
maximum_diameter
from_to
licence_number

Question: Who is the owner/operator of the line from Kambalda to Esperance?
SQL: SELECT "owner_operator" FROM dampier_bunbury_pipeline_2 WHERE "from_to" = 'kambalda to esperance'

Question: What is the name of the line from Karratha to Port Hedland?
SQL: SELECT "name_year_commissioned" FROM dampier_bunbury_pipeline_2 WHERE "from_to" = 'karratha to port hedland'

Question: What is the maximum diameter of the Mid West Gas Pipeline (1999)?
SQL: SELECT "maximum_diameter" FROM dampier_bunbury_pipeline_2 WHERE "name_year_commissioned" = 'mid west gas pipeline (1999)'

Question: Who is the owner operator who has license number PL 59?
SQL: SELECT "owner_operator" FROM dampier_bunbury_pipeline_2 WHERE "licence_number" = 'pl 59'

Question: What is the license number where the maximum diameter is 400 mm?
SQL: SELECT "licence_number" FROM dampier_bunbury_pipeline_2 WHERE "maximum_diameter" = '400 mm'

Question: What is the name where the license number is PL 22?
SQL: SELECT "name_year_commissioned" FROM dampier_bunbury_pipeline_2 WHERE "licence_number" = 'pl 22'