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

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

[hackerrank] Prepare > SQL > Aggregation > Top Earners [문제] We define an employee's total earnings to be their monthly worked, and the maximum total earnings to be the maximum total earnings for any employee in the Employee table. Write a query to find the maximum total earnings for all employees as well as the total number of employees who have maximum total earnings. Then print these values as..

[hackerrank] Prepare > SQL > Aggregation > The Blunder [문제] Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's key was broken until after completing the calculation. She wants your help finding the difference between her miscalculation (using salaries with any zeros removed), and the actual average salary..

[hackerrank] Prepare > SQL > Aggregation > Population Density Difference [문제] Query the difference between the maximum and minimum populations in CITY. Input Format The CITY table is described as follows: [MYSQL] [ORCALE] select max(population)-min(population) from city;

[hackerrank] Prepare > SQL > Aggregation > Japan Population [문제] 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] [ORCALE] select sum(population) from city where countrycode = 'JPN';

[hackerrank] Prepare > SQL > Aggregation > Average Population [문제] Query the average population for all cities in CITY, rounded down to the nearest integer. Input Format The CITY table is described as follows: [MYSQL] [ORCALE] select round(avg(population),0) from city;

[hackerrank] Prepare > SQL > Aggregation > Revising Aggregations - Averages [문제] Query the average population of all cities in CITY where District is California. Input Format The CITY table is described as follows: [MYSQL] [ORCALE] select avg(population) from city where district = 'California';

[hackerrank] Prepare > SQL > Aggregation > > Revising Aggregations - The Sum Function [문제] Query the total population of all cities in CITY where District is California. Input Format The CITY table is described as follows: [MYSQL] [ORCALE] select sum(population) from city where district = 'California';