desc

Weather Observation Station 15 | HackerRank Query the Western Longitude for the largest Northern Latitude under 137.2345, rounded to 4 decimal places. www.hackerrank.com Problem 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. -> lat_n이 137.2345보다 작은 값중에서 제일 큰 lat_n을 가진 long_w를 소수점 4자리에서 ..

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 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 tha..

코딩테스트 연습 - 역순 정렬하기 ANIMAL_INS 테이블은 동물 보호소에 들어온 동물의 정보를 담은 테이블입니다. ANIMAL_INS 테이블 구조는 다음과 같으며, ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE는 각각 동물의 아이디 programmers.co.kr Rocky 2016-06-07 09:17:00 Shelly 2015-01-29 15:01:00 Benji 2016-04-19 13:28:00 Jackie 2016-01-03 16:25:00 *Sam 2016-03-13 11:17:00 ANIMAL_INS 테이블에서 NAME, DATETIME 열을 불러온다. (SELECT NAME, DATETIME FROM ..