The CITY table is described as follows:Problem Statement : Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.
Solution :
For this challenge, we must:
Select all columns using the all-column wildcard (*).
Restrict the selected rows using the WHERE clause so that only records satisfying both of the following two conditions are returned:
COUNTRYCODE is USA, meaning the cities are American.
POPULATION is greater than 100000.
Query :
SELECT *
FROM CITY
WHERE
COUNTRYCODE = 'USA'
AND POPULATION > 100000;
Output:
Hope you understand !!!
If you have any questions let me know in the comment section.
