목록SQL (63)

Milky's note

[HackerRank](E) Population Census

https://www.hackerrank.com/challenges/asian-population/problem?isFullScreen=true Population Census | 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 Forma..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 25. 22:37
[HackerRank](E) Weather Observation Station 17

https://www.hackerrank.com/challenges/weather-observation-station-17/problem?isFullScreen=true&h_r=next-challenge&h_v=zen Weather Observation Station 17 | HackerRank Query the Western Longitude for the smallest value of the Northern Latitudes greater than 38.7780 in STATION and round to 4 decimal places. www.hackerrank.com [문제] Query the Western Longitude (LONG_W)where the smallest Northern Lati..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 25. 17:48
[HackerRank](E) Weather Observation Station 16

https://www.hackerrank.com/challenges/weather-observation-station-16/problem?isFullScreen=true Weather Observation Station 16 | HackerRank Query the smallest of STATION's Northern Latitudes that is greater than 38.7780, and round to 4 decimal places www.hackerrank.com [문제] Query the smallest Northern Latitude (LAT_N) from STATION that is greater than 38.7780. Round your answer to decimal places...
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 25. 17:46
[HackerRank](E) Weather Observation Station 15

https://www.hackerrank.com/challenges/weather-observation-station-15/problem?isFullScreen=true Weather Observation Station 15 | HackerRank Query the Western Longitude for the largest Northern Latitude under 137.2345, rounded to 4 decimal places. www.hackerrank.com [문제] Query the Western Longitude (LONG_W) for the largest Northern Latitude (LAT_N) in STATION that is less than 137.2345. Round your..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 25. 17:43
Prev 1 ··· 3 4 5 6 7 8 9 ··· 16 Next