728x90
문제
https://www.hackerrank.com/challenges/revising-the-select-query-2/problem?isFullScreen=true
Revising the Select Query II | HackerRank
Query the city names for all American cities with populations larger than 120,000.
www.hackerrank.com
풀이(MSSQL)
SELECT NAME
FROM CITY
WHERE POPULATION > 120000
AND COUNTRYCODE LIKE 'USA'
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 I (1) | 2023.12.18 |