Gdp per capita for malawi
CREATE TABLE "list_of_african_countries_by_gdp_per_cap" (
  "gdp_ppp_per_capita_2010_african_world_rank_2010" text,
  "nation" text,
  "gdp_by_agriculture_2010" text,
  "gdp_by_industry_2010" text,
  "gdp_by_services_2010" text,
  "total_gdp_ppp_2010_african_world_rank_2010" text,
  "gdp_real_growth_rate_2010" text
);
SELECT "gdp_ppp_per_capita_2010_african_world_rank_2010" FROM "list_of_african_countries_by_gdp_per_cap" WHERE "nation"='Malawi';