2021/01(20)
-
[HackerRank MySQL] Weather Observation Station 1, 3-12 + REGEXP (Basic) & MOD() Function
Weather Observation Station 1 Query a list of CITY and STATE from the STATION table. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. select city, state from station Weather Observation Station 3 Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates..
2021.01.05 -
[HackerRank MySQL] SELECT, WHERE 문제풀기 (Basic)
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: select * from city where population > 100000 and countrycode = 'usa' Revising the Select Query II Query the NAME field for all American cities in the CITY table with populations larger than 120000...
2021.01.05