[HackerRank, SQL] Revising the Select Query I & II

"Revising the Select Query I & II" from HackerRank

👻문제: Revising the Select Query I

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

👻풀이 (MySQL)

SELECT * FROM CITY WHERE COUNTRYCODE="USA" AND POPULATION>100000

*의 사용 외에는 어려울 것 없는 간단한 SELECT FROM WHERE 연습 문제였다.

---

🥑문제: Revising the Select Query II

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

🥑풀이 (MySQL)

SELECT NAME FROM CITY WHERE COUNTRYCODE="USA" AND POPULATION>120000

위의 문제와 거의 비슷하다.