코딩일기 (127) 썸네일형 리스트형 SQL 코드카타 168 - Binary Tree Nodes https://www.hackerrank.com/challenges/binary-search-tree-1/problem?isFullScreen=true Binary Tree Nodes | HackerRankWrite a query to find the node type of BST ordered by the value of the node.www.hackerrank.com ColumnTypeNIntegerPInteger BST 테이블:N, P : 노드정보를 가진 두 열여기서 N은 이진 트리의 노드 값을 나타내고, P는 N의 부모 노드를 나타냅니다.각 노드의 노드 타입을 찾아 노드의 값으로 정렬하여 출력하는 쿼리를 작성하세요. 각 노드에 대해 다음 중 하나를 출력하세요:Root: 노드가 루트 노드인 경우... SQL 코드카타 167 - Average Population of Each Continent https://www.hackerrank.com/challenges/average-population-of-each-continent/problem?isFullScreen=true Average Population of Each Continent | HackerRankQuery the names of all continents and their respective city populations, rounded down to the nearest integer.www.hackerrank.com FieldTypeIDNUMBERNAMEVARCHAR2 (17)COUNTRYCODEVARCHAR2 (3)DISTRICTVARCHAR2 (20)POPULATIONNUMBER CITY 테이블:ID: 테이블의 고유 키NAM.. SQL 코드카타 166 - African Cities https://www.hackerrank.com/challenges/african-cities/problem?isFullScreen=true African Cities | HackerRankQuery the names of all cities on the continent 'Africa'.www.hackerrank.com FieldTypeIDNUMBERNAMEVARCHAR2 (17)COUNTRYCODEVARCHAR2 (3)DISTRICTVARCHAR2 (20)POPULATIONNUMBER CITY 테이블:ID: 테이블의 고유 키NAME : 도시의 이름COUNTRYCODE : 국가 코드DISTRICT : 지역POPULATION : 인구FieldTypeCODEVARCHAR2 (3)NAMEVARCHAR2 (4.. SQL 코드카타 165 - Population Census https://www.hackerrank.com/challenges/asian-population/problem?isFullScreen=true Population Census | HackerRankQuery the sum of the populations of all cities on the continent 'Asia'.www.hackerrank.com FieldTypeIDNUMBERNAMEVARCHAR2 (17)COUNTRYCODEVARCHAR2 (3)DISTRICTVARCHAR2 (20)POPULATIONNUMBER CITY 테이블:ID: 테이블의 고유 키NAME : 도시의 이름COUNTRYCODE : 국가 코드DISTRICT : 지역POPULATION : 인구 FieldTypeCODEVARCH.. SQL 코드카타 164 - Weather Observation Station 19 https://www.hackerrank.com/challenges/weather-observation-station-19/problem?isFullScreen=true Weather Observation Station 19 | HackerRankQuery the Euclidean Distance between two points and round to 4 decimal digits.www.hackerrank.com FieldTypeIDNUMBERCITYVARCHAR2(21)STATEVARCHAR2(2)LAT_NNUMBERLONG_WNUMBER STATION 테이블:ID: 테이블의 고유 키CITY : 도시의 이름STATE : 주의 이름LAT_N : 위도LONG_W : 경도P1(a, c)와 P2(b, d).. SQL 코드카타 163 - Weather Observation Station 18 https://www.hackerrank.com/challenges/weather-observation-station-18/problem?isFullScreen=true Weather Observation Station 18 | HackerRankQuery the Manhattan Distance between two points, round or truncate to 4 decimal digits.www.hackerrank.com FieldTypeIDNUMBERCITYVARCHAR2(21)STATEVARCHAR2(2)LAT_NNUMBERLONG_WNUMBER STATION 테이블:ID: 테이블의 고유 키CITY : 도시의 이름STATE : 주의 이름LAT_N : 위도LONG_W : 경도P1(a, b)와.. SQL 코드카타 162 - Weather Observation Station 17 https://www.hackerrank.com/challenges/weather-observation-station-17/problem?isFullScreen=true Weather Observation Station 17 | HackerRankQuery 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 FieldTypeIDNUMBERCITYVARCHAR2(21)STATEVARCHAR2(2)LAT_NNUMBERLONG_WNUMBER STATION 테이블:ID: 테이블의 고유 키CITY.. SQL 코드카타 161 - Weather Observation Station 16 https://www.hackerrank.com/challenges/weather-observation-station-16/problem?isFullScreen=true Weather Observation Station 16 | HackerRankQuery the smallest of STATION's Northern Latitudes that is greater than 38.7780, and round to 4 decimal placeswww.hackerrank.com FieldTypeIDNUMBERCITYVARCHAR2(21)STATEVARCHAR2(2)LAT_NNUMBERLONG_WNUMBER STATION 테이블:ID: 테이블의 고유 키CITY : 도시의 이름STATE : 주의 이름LAT_N :.. 이전 1 2 3 4 5 6 7 8 ··· 16 다음