공부/PS ( SQL)
[HackerRank/Basic Select] Revising the Select Query I
happyst
2021. 9. 24. 01:10
https://www.hackerrank.com/challenges/revising-the-select-query/problem
Revising the Select Query I | HackerRank
Query the data for all American cities with populations larger than 100,000.
www.hackerrank.com
SELECT * FROM CITY
WHERE POPULATION > 100000 AND
COUNTRYCODE LIKE 'USA'