HackerRank/해커랭크-Revising the Select Query II-MySQL

문제📖

풀이🙏

• Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.

코드💻

# hackerrank, sql : Revising the Select Query II, mysql
SELECT NAME
FROM CITY
WHERE POPULATION > 120000 AND COUNTRYCODE = 'USA'

결과😎

출처 && 깃허브📝

hackerrank
github