[HackerRank] Revising the Select Query I

mzzzi·2022년 4월 18일
0

HackerRank SQL

목록 보기
1/52
post-thumbnail

MySQL > Revising the Select Query I

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';
profile
무럭무럭 성장하라🌳

0개의 댓글