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

❓ Question

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

Revising the Select Query II | HackerRank

❗ Answer

SELECT name
    FROM city
    WHERE countrycode = 'USA' AND population > 120000;

📌 Discussion

• WHERE 절에서 조건을 걸어주고 SELECT 절에서 필요 컬럼만 추출