Table: energy_companies
Columns: date
company
business
country
value_usd

Question: In New Zealand, what's the value that has an unknown date and is an energy business?
SQL: SELECT "value_usd" FROM energy_companies WHERE "date" = 'unknown' AND "business" = 'energy' AND "country" = 'new zealand'

Question: What company has an unknown date and is an energy business?
SQL: SELECT "company" FROM energy_companies WHERE "business" = 'energy' AND "date" = 'unknown'

Question: In the United Kingdom, what company has an unknown date and is an energy business?
SQL: SELECT "company" FROM energy_companies WHERE "business" = 'energy' AND "date" = 'unknown' AND "country" = 'united kingdom'

Question: For the United Kingdom, what's the date?
SQL: SELECT "date" FROM energy_companies WHERE "country" = 'united kingdom'

Question: For the Enernoc Australia Pty Ltd, what's the country with an unknown date?
SQL: SELECT "country" FROM energy_companies WHERE "date" = 'unknown' AND "company" = 'enernoc australia pty ltd'