SQL Select Query - Select all column

SQL Select Query - Select all columns. Show all columns of USA from the city table which population is greater than 100000. This is the solution of the HackerRank Revising the Select Query I SQL problem.

 

Table Name: CITY 

Table structure:

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

 

SQL Query:

SELECT * FROM CITY 
WHERE ID = 1661;