Table: countries_info_2
Columns: country_with_flag
area_km
population_1_july_2005_est
population_density_per_km
capital

Question: What is the highest value of area when capital is San Juan?
SQL: SELECT MAX("area_km") FROM countries_info_2 WHERE "capital" = 'San Juan'

Question: How many entries for area correspond to a population density of 207.9?
SQL: SELECT COUNT("area_km") FROM countries_info_2 WHERE "population_density_per_km" = '207.9'

Question: What is every entry for area if capital is Port-au-Prince?
SQL: SELECT "area_km" FROM countries_info_2 WHERE "capital" = 'Port-au-Prince'

Question: What is every country with a flag with population of 11346670?
SQL: SELECT "country_with_flag" FROM countries_info_2 WHERE "population_1_july_2005_est" = 11346670

Question: What is the highest value for population when area is 9104?
SQL: SELECT MAX("population_1_july_2005_est") FROM countries_info_2 WHERE "area_km" = 9104