Juwon07

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

Select * 
from city 
where population > 100000 and CountryCode = 'USA';

/*Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. 
Your result cannot contain duplicates*/