내 인생에도 예쁜 꽃이 피었으면 좋겠다

[hackerrank] Prepare > SQL > Aggregation > African Cities [문제] Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is 'Africa'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are described as follows: [MYSQL] [ORCALE] select a.name from city a inner join country b on (a.countrycode = b.code) where contin..

[hackerrank] Prepare > SQL > Aggregation > Population Census [문제] 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 tables are described as follows: [MYSQL] [ORCALE] select sum( a.population) from city a inner join country b on (a.coun..

[hackerrank] Prepare > SQL > Aggregation > Weather Observation Station 19 [문제] Consider and to be two points on a 2D plane where are the respective minimum and maximum values of Northern Latitude (LAT_N) and are the respective minimum and maximum values of Western Longitude (LONG_W) in STATION. Query the Euclidean Distance between points and and format your answer to display decimal digits. Inpu..

[hackerrank] Prepare > SQL > Aggregation > Weather Observation Station 18 [문제] Consider and to be two points on a 2D plane. happens to equal the minimum value in Northern Latitude (LAT_N in STATION). happens to equal the minimum value in Western Longitude (LONG_W in STATION). happens to equal the maximum value in Northern Latitude (LAT_N in STATION). happens to equal the maximum value in Western..

[hackerrank] Prepare > SQL > Aggregation > Weather Observation Station 17 [문제] Query the Western Longitude (LONG_W)where the smallest Northern Latitude (LAT_N) in STATION is greater than . Round your answer to decimal places. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. [MYSQL] [ORCALE] select round(long_w,4) fr..

[hackerrank] Prepare > SQL > Aggregation > Weather Observation Station 16 [문제] Query the smallest Northern Latitude (LAT_N) from STATION that is greater than . Round your answer to decimal places. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. [MYSQL] [ORCALE] select round(lat_n,4) from ( select * from station whe..

[hackerrank] Prepare > SQL > Aggregation > Weather Observation Station 15 [문제] Query the Western Longitude (LONG_W) for the largest Northern Latitude (LAT_N) in STATION that is less than . Round your answer to decimal places. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. [MYSQL] [ORCALE] select round(long_w,4) fr..

[hackerrank] Prepare > SQL > Aggregation > Weather Observation Station 14 [문제] Query the greatest value of the Northern Latitudes (LAT_N) from STATION that is less than . Truncate your answer to decimal places. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. [MYSQL] [ORCALE] select round(max(lat_n),4) from station ..

[hackerrank] Prepare > SQL > Aggregation > Weather Observation Station 13 [문제] Query the sum of Northern Latitudes (LAT_N) from STATION having values greater than and less than . Truncate your answer to decimal places. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. [MYSQL] [ORCALE] select round(sum(lat_n),4) from ..

[hackerrank] Prepare > SQL > Aggregation > Weather Observation Station 2 [문제] Query the following two values from the STATION table: The sum of all values in LAT_N rounded to a scale of decimal places. The sum of all values in LONG_W rounded to a scale of decimal places. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitu..