When green is the map colour what is the future stock?
create table table_17839_1 (future_stock varchar, map_colour varchar, PRIMARY KEY (future_stock))
select future_stock from table_17839_1 where map_colour = "green"