Revising the Select Query I
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:
Solution: SELECT * FROM CITY WHERE population >100000 AND CountryCode = "USA";
Explanation:
This query selects all columns (*) from the CITY table where the population is greater than 100,000 and the CountryCode is 'USA'.
Breaking it down:
SELECT *: This part of the query selects all columns from the CITY table.
FROM CITY: This specifies the table from which the data will be retrieved, in this case, the CITY table.
WHERE Population >100000 : This is a condition that filters the rows. It ensures that only cities with populations greater than 100,000 are included.
AND CountryCode = "USA": This is another condition added to the WHERE clause. It ensures that only cities with the country code 'USA' are included, effectively selecting only American cities.
So, the result of this query will be all columns for all American cities in the CITY table with populations larger than 100,000.
Last updated