Query all columns for all American cities in the CITY table with populations larger than 100000
. The CountryCode for America is USA
.
The CITY table is described as follows:
![](https://s3.amazonaws.com/hr-challenge-images/8137/1449729804-f21d187d0f-CITY.jpg)
SOLUTION :-
SELECT *
FROM City
WHERE CountryCode = ‘USA’ AND Population > 100000;
FOLLOW FOR MORE QUESTIONS AND SOLUTIONS |Â DIGIT WOOD
Leave a Reply