서울 워킹 홀리데이

Query the Western Longitude (LONG_W)where the smallest Northern Latitude (LAT_N) in STATION is greater than 38.7780. Round your answer to 4 decimal places. ​ ​ ​ ​ *서브쿼리 (SubQuery)

Query the smallest Northern Latitude (LAT_N) from STATION that is greater than 38.7780. Round your answer to 4 decimal places. ​ ​ *서브쿼리 (SubQuery)

Query the Western Longitude (LONG_W) for the largest Northern Latitude (LAT_N) in STATION that is less than 137.2345. Round your answer to 4 decimal places. ​ ​ *서브쿼리 (SubQuery)

Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically. ​ ​ 이름이 가장 짧은 도시와 가장 긴 도시의 이름과 길이를 각각 추출하고, 만약 길이가 같다면 이름의 알파벳 순으로 출력해라. ​ ​ [ORACLE] ​ ​ *서브쿼리 (SubQuery)