SQL 문제풀이

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

냄비짱 2023. 8. 15. 23:56
728x90

❓ Question

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

 

Revising the Select Query I | HackerRank

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

www.hackerrank.com

❗ Answer

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

📌 Discussion

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