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

문제📖

풀이🙏

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

쿼리문💻

# HackerRank, sql : revising the select query 1, MySQL
SELECT *
FROM CITY
WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA'

결과😎

출처 && 깃허브📝

https://www.hackerrank.com/challenges/revising-the-select-query/problem
github