HackerRank mysql

[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] 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..

[Hackerrank SQL] Weather Observation Station 5

www.hackerrank.com/challenges/weather-observation-station-5/problem?h_r=next-challenge&h_v=zen 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 Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characte..