문제
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;
'algorithm' 카테고리의 다른 글
[HackerRank] MySQL - Weather Observation Station 3 (0) | 2022.08.12 |
---|---|
[programmers] MySQL - Lv.2 이름에 el이 들어가는 동물 찾기 (string, date) (0) | 2022.08.12 |
[programmers] MySQL - Lv.2 동명 동물 수 찾기 (group by) (0) | 2022.08.11 |
[HackerRank] Java - Welcome to Java! (0) | 2022.08.11 |
[HackerRank] MySQL - Japanese Cities' Names (0) | 2022.08.11 |