Basic Select SQL Queries

SELECT * FROM CITY WHERE ID = 1661;

select * from city where countrycode='JPN';

select name from city where population> 120000 and countrycode='USA';

SELECT DISTINCT CITY FROM STATION WHERE CITY NOT LIKE 'A%' AND CITY NOT LIKE 'E%' AND CITY NOT LIKE 'I%' AND CITY NOT LIKE 'O%' AND CITY NOT LIKE 'U%';

select city, state from station;

SELECT * FROM CITY WHERE CountryCode = 'USA' AND Population > 100000;

SELECT COUNT(CITY) - COUNT(DISTINCT CITY) FROM STATION;