반응형 CODING TEST/SQL : HackerRank31 [MySQL] Revising the Select Query I SQL > Basic Select > Revising the Select Query I Problem 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: My Answer SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA' 2021. 3. 26. 이전 1 ··· 3 4 5 6 다음 반응형
