[해커랭크 SQL] Basic Select - Revising the Select Query I

❓ Question

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

Revising the Select Query I | HackerRank

❗ Answer

SELECT *
    FROM city
    WHERE countrycode = 'USA' AND population > 100000;

📌 Discussion

• WHERE 절에서 조건문으로 필터링