[SQL] 조건문을 활용한 모든 데이터 조회하기

 

Table of Contents

1. Question
2. Answer
3. Reference

 

Question

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:

[image 1] Table description

 

 

Answer

Question quest us how to query all columns for all America cities. And it tell us they have populations larger than 100000. So, We use "Condition Filtering".

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

 

 

Reference

"Condition Filtering", MySQL,  https://dev.mysql.com/doc/refman/8.0/en/condition-filtering.html

"Revising the Select Query", hackerrank, https://www.hackerrank.com/challenges/revising-the-select-query/