All countries with population > 100,000,000:

query("SELECT * FROM countries WHERE population > 100000000 AND surface_area > 1000000;"); // Iterate over the records it returned, outputting some information from each in an
• . foreach ($stmt as $record) { ?>
• ()