전체 글 썸네일형 리스트형 [HackerRank][SQL] Weather Observation Station 14 - 컴도리돌이 Weather Observation Station 14 | HackerRank Query the greatest value of the Northern Latitudes from STATION that are under 137.2345 and truncated to 4 decimal places. www.hackerrank.com Problem Query the greatest value of the Northern Latitudes (LAT_N) from STATION that is less than 137.2345 . Truncate your answer to 4 decimal places. -> lat_n이 137.2345 보다 작은 값중에서 제일 큰 값을 소수점 4자리로 출력하시오. Answer .. 더보기 [HackerRank][SQL] Weather Observation Station 13 - 컴도리돌이 Weather Observation Station 13 | HackerRank Query the sum of Northern Latitudes having values greater than 38.7880 and less than 137.2345, truncated to 4 decimal places. www.hackerrank.com Problem Query the sum of Northern Latitudes (LAT_N) from STATION having values greater than 38.7880 and less than 137.2345 . Truncate your answer to 4 decimal places. -> 38.7880보다 크고 137.2345보다 작은 값을 가진 STATIO.. 더보기 [HackerRank][SQL][JOIN] Basic Join, Challenges - 컴도리돌이 Challenges | HackerRank Print the total number of challenges created by hackers. www.hackerrank.com Problem Julia asked her students to create some coding challenges. Write a query to print the hacker_id, name, and the total number of challenges created by each student. Sort your results by the total number of challenges in descending order. If more than one student created the same number of ch.. 더보기 [HackerRank][SQL][JOIN] Basic Join, Population Census - 컴도리돌이 Population Census | HackerRank Query the sum of the populations of all cities on the continent 'Asia'. www.hackerrank.com Problem Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'. -> 아시아에 있는 모든 도시의 인구 수의 합을 출력하시오. Answer select sum(a.population) from city a inner join country b on a.countrycode = b.code where b.continent = "Asia" 더보기 [HackerRank][SQL][JOIN] Basic Join, Ollivander's Inventory - 컴도리돌이 Ollivander's Inventory | HackerRank Help pick out Ron's new wand. www.hackerrank.com Problem Harry Potter and his friends are at Ollivander's with Ron, finally replacing Charlie's old broken wand. Hermione decides the best way to choose is by determining the minimum number of gold galleons needed to buy each non-evil wand of high power and age. Write a query to print the id, age, coins_needed, a.. 더보기 [HackerRank][SQL] Weather Observation Station 12 - 컴도리돌이 Weather Observation Station 12 | HackerRank Query an alphabetically ordered list of CITY names not starting and ending with vowels. www.hackerrank.com Problem Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates. -> 도시 이름의 시작과 끝이 모음이 포함하지 않는 도시의 이름을 중복 없이 출력하시오. Answer select distinct(city) from station where ci.. 더보기 [HackerRank][SQL] Weather Observation Station 10 - 컴도리돌이 Weather Observation Station 10 | HackerRank Query a list of CITY names not ending in vowels. www.hackerrank.com Problem Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates. -> 모음으로 끝나지 않는 도시 이름을 중복 없이 출력하시오. Answer select distinct(city) from station where city regexp "[^aeiou]$" 더보기 [HackerRank][SQL] Weather Observation Station 9 - 컴도리돌이 Weather Observation Station 9 | HackerRank Query an alphabetically ordered list of CITY names not starting with vowels. www.hackerrank.com Problem Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates. -> 모음으로 시작하지 않는 도시 이름을 중복 없이 출력하시오. Answer select distinct(city) from station where city regexp "^[^aeiou]" 더보기 이전 1 ··· 13 14 15 16 17 18 19 ··· 41 다음
