뉴에이지의 DATABASE

DATA SCIENCE/SQL

문제 https://www.hackerrank.com/challenges/revising-the-select-query-2/problem 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: 풀이 1) population이 120,000보다 크고 2) CountryCode가 USA인 모든 name 목록을 출력하면 되는 간단한 문제이다. Language: MySQL SELECT name FROM city WHERE population > 120000..

2021. 12. 21.

DATA SCIENCE/SQL

문제 https://www.hackerrank.com/challenges/revising-the-select-query/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: 풀이 1) population이 100,000보다 크고 2) CountryCode가 USA인 모든 American cities 목록을 출력하면 되는 간단한 문제이다. Language: MySQL select * from CITY where POPULATION > 100..

2021. 12. 20.