HackerRank SQL — All Details of American Cities with Population Over 100000

This one felt familiar right away. It is pretty similar to the problem where I filtered American cities by population, except this time they want all the columns instead of just the city name.

So SELECT star is back, and the conditions are COUNTRYCODE has to be USA and the population has to be more than 100000.

Here is what I wrote:

SELECT *
FROM CITY
WHERE COUNTRYCODE = 'USA'
AND POPULATION > 100000;

SELECT star pulls every column from the table. FROM CITY is the table we are working with. The WHERE part has two conditions again connected with AND, so both have to be true for a row to show up in the result. The city has to be American and its population has to cross 100000.

Nothing new here really. Just a mix of things from the earlier problems put together. SELECT star from the very first problems, AND condition from the city names problem, same CITY table.

At this point the Basic Select problems are starting to feel like building blocks. Each one adds something small and before you know it you are combining all of it without even thinking about it.