SELECT `Name`, `Population` FROM country WHERE `Population` >= 100000000 AND `Population` <= 170115000 ORDER BY `Population`;

SELECT `Name`, `Population` FROM country WHERE `Population` BETWEEN 100000000 AND 170115000 ORDER BY `Population`;

SELECT * FROM country WHERE `HeadOfState` = '' OR `HeadOfState` IS NULL;

SELECT * FROM country WHERE `Code` = 'ABW' AND `HeadOfState` IS NULL;

SELECT `Name`, `Population`, `IndepYear`, `Continent` FROM country WHERE `IndepYear` IS NULL OR `Population` > 4000000 AND `Continent` = 'North America' ORDER BY `Population`;

SELECT `Name`, `Population`, `IndepYear`, `Continent` FROM country WHERE (`IndepYear` IS NULL OR `Population` > 4000000) AND `Continent` = 'North America' ORDER BY `Population`;

SELECT * FROM city WHERE `CountryCode` = 'ABW' OR `CountryCode` = 'AFG' OR `CountryCode` = 'AGO';

SELECT * FROM city WHERE `CountryCode` IN ('ABW', 'AFG', 'AGO');

SELECT * FROM city WHERE `CountryCode` NOT IN ('ABW', 'AFG', 'AGO');