기록하는 습관

Problem HackerRank > Prepare > SQL > Basic Select > Revising the Select Query I Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA. The CITY table is described as follows: Solution 더보기 SELECT * FROM CITY WHERE 1=1 and COUNTRYCODE = 'USA' and POPULATION > 100000 ;