[hackerrank] Select All [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/SQL 2022.08.08
[hackerrank] Revising the Select Query II [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; HackerRank/SQL 2022.08.08
[hackerrank] Revising the Select Query I 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; HackerRank/SQL 2022.08.08