HackerRank SQL — All Details of American Cities...

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