[SQL] 조건문을 활용한 특정 칼럼 조회하기

Table of Contents

1. Question
2. Answer
3. Reference

 

Question

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:

[image 1] Table description

 

 

Answer

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

MYSQL : 

SELECT NAME
  FROM CITY
 WHERE POPULATION > 120000
   AND COUNTRYCODE = 'USA'

 

ORACLE: 

SELECT NAME
  FROM CITY
 WHERE POPULATION > 120000
   AND COUNTRYCODE = 'USA'

 

 

 

 

Reference

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

"About SQL Conditions", Oracle,  https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/About-SQL-Conditions.html

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