[Weather Observation Station 1]
https://www.hackerrank.com/challenges/weather-observation-station-1/problem?isFullScreen=true
Weather Observation Station 1 | HackerRank
Write a query to print the CITY and STATE for each attribute in the STATION table.
www.hackerrank.com
[Problem]
[Solution]
[Weather Observation Station 3]
https://www.hackerrank.com/challenges/weather-observation-station-3/problem?isFullScreen=true
Weather Observation Station 3 | HackerRank
Query a list of unique CITY names with even ID numbers.
www.hackerrank.com
[Problem]
[Solution]
[Weather Observation Station 4]
https://www.hackerrank.com/challenges/weather-observation-station-4/problem?isFullScreen=true
Weather Observation Station 4 | HackerRank
Find the number of duplicate CITY names in STATION.
www.hackerrank.com
[Problem]
[Solution]
[Weather Observation Station 5]
https://www.hackerrank.com/challenges/weather-observation-station-5/problem?isFullScreen=true
Weather Observation Station 5 | HackerRank
Write a query to print the shortest and longest length city name along with the length of the city names.
www.hackerrank.com
[Problem]
[Example]
※ Hint
[Solution]
'전공 > Database' 카테고리의 다른 글
| [이론] 뷰(VIEW)와 시스템 카탈로그 (0) | 2022.04.04 |
|---|---|
| [실습] SQL문 (0) | 2022.03.29 |
| [이론] SQL 제어어(DCL) (0) | 2022.03.18 |
| [이론] SQL 조작어(DML) (0) | 2022.03.15 |
| [이론] SQL 정의어(DDL) (0) | 2022.03.14 |
