Revising the Select Query II | Hackerrank SQL Solution | MYSQL

 Problem Statement

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:.

                                   Video Solution:

APPROACH

1. First select name column

2. Then use two condition

a) POPULATION > 120000

b) COUNTRYCODE="USA"

MYSQL QUERY

select name from city

where POPULATION > 120000 and  COUNTRYCODE="USA" ;

Explanation
1. select name 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...💖💖💖