Renewable Energy Share

entity Entity	code Code	year Year	electricity_from_wind_twh Electricity From Wind (TWh)	electricity_from_hydro_twh Electricity From Hydro (TWh)	electricity_from_solar_twh Electricity From Solar (TWh)	other_renewables_including_bioenergy_twh Other Renewables Including Bioenergy (TWh)
ASEAN (Ember)	nan	2000		50.37		22.53
ASEAN (Ember)	nan	2001		54.26		22.42
ASEAN (Ember)	nan	2002		53.32		22.67
ASEAN (Ember)	nan	2003		53.28		22.43
ASEAN (Ember)	nan	2004		52.88		24.14
ASEAN (Ember)	nan	2005	0.02	53.76		24.44
ASEAN (Ember)	nan	2006	0.05	60.38		24.89
ASEAN (Ember)	nan	2007	0.06	63.13		26.68
ASEAN (Ember)	nan	2008	0.06	69.8		28.75
ASEAN (Ember)	nan	2009	0.07	73.52	0.01	29.73


CREATE TABLE modern_renewable_prod (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "electricity_from_wind_twh" DOUBLE,
  "electricity_from_hydro_twh" DOUBLE,
  "electricity_from_solar_twh" DOUBLE,
  "other_renewables_including_bioenergy_twh" DOUBLE
);