https://www.hackerrank.com/challenges/japanese-cities-attributes/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Japanese Cities' Attributes | HackerRank Query the attributes of all the cities in Japan. www.hackerrank.com select * from city where countrycode = 'JPN';

https://www.hackerrank.com/challenges/select-by-id/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Select By ID | HackerRank Query the details of the city with ID 1661. www.hackerrank.com SELECT * FROM CITY WHERE ID = 1661;

https://www.hackerrank.com/challenges/select-all-sql/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Select All | HackerRank Query all columns for every row in a table. www.hackerrank.com SELECT * FROM CITY