[HackerRank/SQL] 01. Easy - Revising the SELECT query Ⅰ

jwKim·2023년 1월 4일
0

💻코테코테

목록 보기
2/42

< 과제 >

Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.

The CITY table is described as follows:

< 내 코드 >

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

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

0개의 댓글