Im between cherry

Hackerrank | MySQL | Revising the Select Query I 본문

데이터분석/practice_query

Hackerrank | MySQL | Revising the Select Query I

meal 2020. 8. 27. 17:51

Revising the Select Query I

 

Problem

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:

Solution

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

'데이터분석 > practice_query' 카테고리의 다른 글

Hackerrank | MySQL |Japanese Cities' Names  (0) 2020.08.27
Hackerrank | MySQL | Japanese Cities' Attributes  (0) 2020.08.27
Hackerrank | MySQL | Select By ID  (0) 2020.08.27
Hackerrank | MySQL | Select All  (0) 2020.08.27
Hackerrank | MySQL | Revising the Select Query II  (0) 2020.08.27
'데이터분석/practice_query' Related Articles more
Comments