문제 풀이/Hackerrank SQL

[Hackerrank SQL] Ollivander's Inventory

www.hackerrank.com/challenges/harry-potter-and-wands/problem Ollivander's Inventory | HackerRank Help pick out Ron's new wand. www.hackerrank.com 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..

[Hackerrank SQL] The Report

www.hackerrank.com/challenges/the-report/problem The Report | HackerRank Write a query to generate a report containing three columns: Name, Grade and Mark. www.hackerrank.com Ketty gives Eve a task to generate a report containing three columns: Name, Grade and Mark. Ketty doesn't want the NAMES of those students who received a grade lower than 8. The report must be in descending order by grade -..

[Hackerrank SQL] Average Population of Each Continent

www.hackerrank.com/challenges/average-population-of-each-continent/problem Average Population of Each Continent | HackerRank Query the names of all continents and their respective city populations, rounded down to the nearest integer. www.hackerrank.com Given the CITY and COUNTRY tables, query the names of all the continents (COUNTRY.Continent) and their respective average city populations (CITY..

[Hackerrank SQL] Type of Triangle

www.hackerrank.com/challenges/what-type-of-triangle/problem Type of Triangle | HackerRank Query a triangle's type based on its side lengths. www.hackerrank.com Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output one of the following statements for each record in the table: Equilateral: It's a triangle with sides of equal length. Isosceles..

[Hackerrank SQL] Weather Observation Station 13

www.hackerrank.com/challenges/weather-observation-station-13/problem 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 연산에 관한 문제이다. select truncate(sum(LAT_N),4) from STATION WHERE LAT_N > 38.7880 AND lat_n

[Hackerrank SQL] Weather Observation Station 8

www.hackerrank.com/challenges/weather-observation-station-8/problem?h_r=next-challenge&h_v=legacy&h_r=next-challenge&h_v=zen Weather Observation Station 8 | HackerRank Query CITY names that start AND end with vowels. www.hackerrank.com Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicat..