728x90
❓ Question
https://www.hackerrank.com/challenges/weather-observation-station-1
Weather Observation Station 1 | HackerRank
Write a query to print the CITY and STATE for each attribute in the STATION table.
www.hackerrank.com

❗ Answer
SELECT city, state
FROM station;
📌 Discussion
- SELECT 원하는 컬럼만 추출
'SQL 문제풀이' 카테고리의 다른 글
| [해커랭크 SQL] Basic Select - Weather Observation Station 4 (0) | 2023.08.16 |
|---|---|
| [해커랭크 SQL] Basic Select - Weather Observation Station 3 (0) | 2023.08.16 |
| [해커랭크 SQL] Basic Select - Japanese Cities' Names (0) | 2023.08.16 |
| [해커랭크 SQL] Basic Select - Japanese Cities' Attributes (0) | 2023.08.16 |
| [해커랭크 SQL] Basic Select - Select By ID (0) | 2023.08.16 |