혜온의 이것저것

[HackerRank] Revising the Select Query II (MySQL) 본문

Data Analysis/SQL

[HackerRank] Revising the Select Query II (MySQL)

혜온 :) 2022. 8. 3. 11:14

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

 

문제

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:

풀이
select name from city
where population > 120000 && countrycode = 'USA'
저작자표시

'Data Analysis > SQL' 카테고리의 다른 글

[HackerRank] Select By ID (MySQL)  (0) 2022.08.03
[HackerRank] Select All (MySQL)  (0) 2022.08.03
[HackerRank] Revising the Select Query I (MySQL)  (0) 2022.08.03
[Programmers] 코딩테스트 연습 SQL - level4  (0) 2022.06.29
[Programmers] 코딩테스트 연습 SQL - level3  (0) 2022.04.13
'Data Analysis/SQL' Related Articles more
Comments