![]()
Weather Observation Station 17 | HackerRank Query the Western Longitude for the smallest value of the Northern Latitudes greater than 38.7780 in STATION and round to 4 decimal places. www.hackerrank.com Problem 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. -> lat_n 이 38.7780보다 큰 lat_n중에..
![]()
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..
![]()
코딩테스트 연습 - 상위 n개 레코드 ANIMAL_INS 테이블은 동물 보호소에 들어온 동물의 정보를 담은 테이블입니다. ANIMAL_INS 테이블 구조는 다음과 같으며, ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE는 각각 동물의 아이디 programmers.co.kr A399552 Dog 2013-10-14 15:38:00 Normal Jack Neutered Male A379998 Dog 2013-10-23 11:42:00 Normal Disciple Intact Male A370852 Dog 2013-11-03 15:04:00 Normal Katie Spayed Female A403564 Dog 2013-11-1..
![]()
코딩테스트 연습 - 최댓값 구하기 ANIMAL_INS 테이블은 동물 보호소에 들어온 동물의 정보를 담은 테이블입니다. ANIMAL_INS 테이블 구조는 다음과 같으며, ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE는 각각 동물의 아이디 programmers.co.kr A399552 Dog 2013-10-14 15:38:00 Normal Jack Neutered Male A379998 Dog 2013-10-23 11:42:00 Normal Disciple Intact Male A370852 Dog 2013-11-03 15:04:00 Normal Katie Spayed Female A403564 Dog 2013-11-18 ..
