Basic Select SQL Queries

answer: SELECT * FROM CITY WHERE ID = 1661;

answer: SELECT * FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION > 100000;

answer: SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN';

answer: SELECT COUNT(*) - COUNT(DISTINCT CITY) FROM STATION;

answer: SELECT NAME FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION > 120000;

answer: SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN';

answer: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%';

answer: SELECT * FROM CITY;

answer: SELECT CITY, STATE FROM STATION;