Query all columns for all American cities in the CITY table with populations larger than 100000. The COUNTRYCODE for America is USA.

Add a description, image, and links to the hackerrank-sql-solution topic page so that developers can more easily learn about it.