Lim Seunghyun Space

[HackerRank] Revising the Select Query I 본문

SQL/SQL 문제

[HackerRank] Revising the Select Query I

Lim Seung Hyun 2021. 11. 19. 09:55

문제 : https://www.hackerrank.com/challenges/revising-the-select-query/problem?isFullScreen=true 

 

Revising the Select Query I | HackerRank

Query the data for all American cities with populations larger than 100,000.

www.hackerrank.com

 

문제 해설

  • CITY 테이블에서 populations이 100000보다 크고 CountryCode가 USA인 데이터를 SELECT
  • OUTPUT 조건은 모든 칼럼 조회

 

풀이 (MySQL)

SELECT *
FROM CITY
WHERE POPULATION > 100000 AND COUNTRYCODE = "USA";

 

 

728x90

'SQL > SQL 문제' 카테고리의 다른 글

[HackerRank] Japanese Cities' Names  (0) 2021.11.19
[HackerRank] Japanese Cities' Attributes  (0) 2021.11.19
[HackerRank] Select By ID  (0) 2021.11.19
[HackerRank] Select All  (0) 2021.11.19
[HackerRank] Revising the Select Query II  (0) 2021.11.19
'SQL/SQL 문제' Related Articles more