융무의 기술블로그
article thumbnail
[SQL][HackerRank] Asian Population
Algorithm/SQL 2020. 6. 13. 16:42

https://www.hackerrank.com/challenges/asian-population/problem Asian Population | HackerRank Query the sum of the populations of all cities on the continent 'Asia'. www.hackerrank.com Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY t..

article thumbnail
[SQL][HackerRank] The Report
Algorithm/SQL 2020. 6. 12. 14:09

https://www.hackerrank.com/challenges/the-report/problem?h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen The Report | H..

article thumbnail
[SQL][HackerRank] Weather Observation Station 16
Algorithm/SQL 2020. 6. 12. 13:50

https://www.hackerrank.com/challenges/weather-observation-station-16/problem?h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen&h_r=next-challenge&h_v=zen Weather Observation S..

article thumbnail
[SQL][HackerRank] Weather Observation Station 15
Algorithm/SQL 2020. 6. 12. 13:47

https://www.hackerrank.com/challenges/weather-observation-station-15/problem?h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_r%5B%5D=next-challenge&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen&h_v%5B%5D=zen Weather Observation Station 15 | HackerRank Quer..

article thumbnail
[SQL][HackerRank] Weather Observation Station 14
Algorithm/SQL 2020. 6. 12. 12:29

https://www.hackerrank.com/challenges/weather-observation-station-14/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen 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 ..

article thumbnail
[SQL][HackerRank] Weather Observation Station 13
Algorithm/SQL 2020. 6. 12. 12:28

https://www.hackerrank.com/challenges/weather-observation-station-13/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen 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.c..

article thumbnail
[SQL][HackerRank] Weather Observation Station 2
Algorithm/SQL 2020. 6. 12. 12:24

https://www.hackerrank.com/challenges/weather-observation-station-2/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Weather Observation Station 2 | HackerRank Write a query to print the sum of LAT_N and the sum of LONG_W separated by space, rounded to 2 decimal places. www.hackerrank.com Query the following two values from the S..

article thumbnail
[SQL][HackerRank] Top Earners
Algorithm/SQL 2020. 6. 12. 12:21

https://www.hackerrank.com/challenges/earnings-of-employees/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Top Earners | HackerRank Find the maximum amount of money earned by any employee, as well as the number of top earners (people who have earned this amount). www.hackerrank.com We define an employee’s total earnings to be their monthly salary x month..