select *  from city where population > 100000 and city.countrycode = 'USA'

select * from city

select * from city where city.id = 1661

select * from city where city.countrycode = 'JPN'

select city.name from city where city.countrycode = 'JPN'

select s.city, s.state  from station as s

select distinct s.city from station as s where s.id % 2 = 0

select (count(s.city) - count(distinct s.city)) from station as s

select s.city, char_length(s.city) as cl from station as s order by cl, s.city limit 1;
select s.city, char_length(s.city) as cl from station as s order by cl desc, s.city asc limit 1;

select distinct s.city from station as s where s.city like 'a%' or s.city like 'e%' or s.city like 'i%' or s.city like 'o%' or s.city like 'u%'

select distinct s.city from station as s where s.city REGEXP "^[aeiou].*";

select distinct s.city from station as s where s.city REGEXP ".*[aeiou]$";

select distinct s.city from station as s where s.city REGEXP "^[aeiou].*[aeiou]$";

select distinct s.city from station as s where s.city REGEXP "^[^aioeu].*";

select distinct s.city from station as s where s.city REGEXP ".*[^aioeu]$";

select distinct s.city from station as s where s.city REGEXP "(^[^aioeu].*)|(.*[^aioeu]$)";

select distinct s.city from station as s where s.city REGEXP "(^[^aioeu].*[^aioeu]$)";