[SQL문제풀기] Revising the Select Query I

문제

Revising the Select Query I | HackerRank

Query the data for all American cities with populations larger than 100,000.

https://www.hackerrank.com/challenges/revising-the-select-query/problem?isFullScreen=true

MySQL , MS SQL Server

내가 작성한 정답

select *
from city
where population > 100000 and countrycode = 'USA'

Oracle, DB2

내가 작성한 정답

select * 
from city
where countrycode = 'USA' and population > 100000;