SQL Select Query - Select a single column

Author: Al-mamun Sarkar Date: 2020-03-26 15:00:20

SQL Select Query - Select a single column. Show all names of the USA from the city table which population is greater than 120000. This is the solution of the HackerRank Revising the Select Query II SQL problem.

 

Table Name: CITY 

Table structure:

Field Type
ID NUMBER
NAME VARCHAR
COUNTRYCODE VARCHAR
DISTRICT VARCHA
POPULATION NUMBER

 

SQL Query:

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

 

<- Previous Next ->