목록MySQL (43)

Milky's note

[HackerRank](E) Weather Observation Station 2

https://www.hackerrank.com/challenges/weather-observation-station-2/problem?isFullScreen=true 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 STATION table: The sum of all values in LAT_N rounded to a scale of decimal places. Th..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 25. 17:29
[HackerRank](E) The Blunder

https://www.hackerrank.com/challenges/the-blunder/problem?isFullScreen=true The Blunder | HackerRank Query the amount of error in Sam's result, rounded up to the next integer. www.hackerrank.com [문제] Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's 0 key was broken until after completing the calculation..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 25. 16:46
[HackerRank](E) Population Density Difference

https://www.hackerrank.com/challenges/population-density-difference/problem?isFullScreen=true Population Density Difference | HackerRank Query the difference between the maximum and minimum city populations in CITY. www.hackerrank.com [문제] Query the difference between the maximum and minimum populations in CITY. Input Format The CITY table is described as follows: [답] -mysql select max(populatio..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 25. 16:13
[HackerRank](E) Japan Population

https://www.hackerrank.com/challenges/japan-population/problem?isFullScreen=true Japan Population | HackerRank Query to the sum of the populations of all Japanese cities in CITY. www.hackerrank.com [문제] Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN. Input Format The CITY table is described as follows: [답] -mysql select sum(population) from cit..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 25. 16:06
Prev 1 ··· 3 4 5 6 7 8 9 ··· 11 Next