HackerRank SQL | Revising the Select Query I | codewitharyan

Problem Statement

Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.

Video Solution:

APPROACH

1. First select all the column

2. Then use two condition

a) POPULATION > 100000

b) COUNTRYCODE="USA"

MYSQL QUERY

select * from city

where POPULATION > 100000 and  COUNTRYCODE="USA" ;

Explanation

1. select * from city : It is used to select all the
column from the table city.

2. where : It is used to describe conditions





Thank You For Visiting...💖💖💖