7 lines
183 B
SQL
7 lines
183 B
SQL
-- Author: Rodney Shaghoulian
|
|
-- Github: github.com/RodneyShag
|
|
-- HackerRank: hackerrank.com/RodneyShag
|
|
|
|
SELECT * FROM CITY
|
|
WHERE COUNTRYCODE = 'USA' AND POPULATION > 100000;
|