[HackerRank/SQL] 02. Easy - Revising the Select Query II

jwKim·2023년 1월 5일
0

💻코테코테

목록 보기
4/42

< 과제 >

Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.

The CITY table is described as follows:
img

< 내 코드 >

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

< 출처 >
https://www.hackerrank.com/domains/sql

0개의 댓글