What is the name of the country with the highest percentage of rural population in the overall total population? Indicate the rural population percentage of total population.
the highest percentage of rural population in the overall total population refers to max(value where indicatorname = 'Rural population (% of total population)')
SELECT countryname, MAX(value) FROM indicators WHERE indicatorname = 'Rural population (% of total population)'