Milky's note

https://www.hackerrank.com/challenges/japanese-cities-name/problem?isFullScreen=true Japanese Cities' Names | HackerRank In this challenge, you will query a list of all the Japanese cities' names. www.hackerrank.com [문제] Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN. The CITY table is described as follows: [답] - oracle select name from city where ..

https://www.hackerrank.com/challenges/japanese-cities-attributes/problem?isFullScreen=true Japanese Cities' Attributes | HackerRank Query the attributes of all the cities in Japan. www.hackerrank.com [문제] Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN. The CITY table is described as follows: [답] - oracle select * from city where countrycode = 'JPN';

https://www.hackerrank.com/challenges/select-by-id/problem?isFullScreen=true Select By ID | HackerRank Query the details of the city with ID 1661. www.hackerrank.com [문제] Query all columns for a city in CITY with the ID 1661. The CITY table is described as follows: [답] - oracle select * from city where ID = '1661';

https://www.hackerrank.com/challenges/select-all-sql/problem?isFullScreen=true Select All | HackerRank Query all columns for every row in a table. www.hackerrank.com [문제] Query all columns (attributes) for every row in the CITY table. The CITY table is described as follows: [답] - oracle select * from city;