내 인생에도 예쁜 꽃이 피었으면 좋겠다

[hackerrank] Prepare > SQL > Basic Select > Japanese Cities' Names [문제] 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: [MYSQL] [ORCALE] select name from city where countrycode = 'JPN';

[hackerrank] Prepare > SQL > Basic Select > Japanese Cities' Attributes [문제] Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN. The CITY table is described as follows: [MYSQL] [ORCALE] select * from city where countrycode = 'JPN';

[hackerrank] Prepare > SQL > Basic Select > Select By ID [문제] Query all columns for a city in CITY with the ID 1661. The CITY table is described as follows: [MYSQL] [ORCALE] select * from city where id = 1661;

[hackerrank] Prepare > SQL > Basic Select > Select All [문제] Query all columns (attributes) for every row in the CITY table. The CITY table is described as follows: [MYSQL] [ORCALE] select * from city;

[hackerrank] Prepare > SQL > Basic Select > Revising the Select Query II [문제] Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA. The CITY table is described as follows: [MYSQL] [ORCALE] select name from city where countrycode = 'USA' and population > 120000;

Prepare > SQL > Basic Select > Revising the Select Query I [문제] Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA. The CITY table is described as follows: [MYSQL] select * from city where countrycode = 'USA' and population > 100000 ; [ORACLE] select * from city where countrycode = 'USA' and population > 100000;