728x90
728x90
문제
https://www.hackerrank.com/challenges/revising-the-select-query/problem?isFullScreen=true
Revising the Select Query I | HackerRank
Query the data for all American cities with populations larger than 100,000.
www.hackerrank.com
풀이(MSSQL)
SELECT *
FROM CITY
WHERE COUNTRYCODE LIKE 'USA'
AND POPULATION > 100000
CountryCode가 USA 이면서 Population이 100000보다 큰 경우가 조건으로 SELECT를 해야한다.
728x90
300x250
'SQL > HACKERRANK' 카테고리의 다른 글
| Japanese Cities' Names (0) | 2023.12.18 |
|---|---|
| Japanese Cities' Attributes (0) | 2023.12.18 |
| Select By ID (0) | 2023.12.18 |
| Select All (0) | 2023.12.18 |
| Revising the Select Query II (0) | 2023.12.18 |