Oneulog

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: Code SELECT SUM(POPULATION) FROM CITY WHERE ..

https://www.hackerrank.com/challenges/average-population/problem?isFullScreen=true Average Population | HackerRank Query the average population of all cities, rounded down to the nearest integer. www.hackerrank.com 문제 Query the average population for all cities in CITY, rounded down to the nearest integer. Input Format The CITY table is described as follows: Code SELECT ROUND(AVG(POPULATION)) FR..

https://www.hackerrank.com/challenges/revising-aggregations-the-average-function/problem?isFullScreen=true Revising Aggregations - Averages | HackerRank Query the average population of all cities in the District of California. www.hackerrank.com 문제 Query the average population of all cities in CITY where District is California. Input Format The CITY table is described as follows: Code SELECT AVG..

https://www.hackerrank.com/challenges/revising-aggregations-sum/problem?isFullScreen=true Revising Aggregations - The Sum Function | HackerRank Query the total population of all cities for in the District of California. www.hackerrank.com 문제 Query the total population of all cities in CITY where District is California. Input Format The CITY table is described as follows: Code SELECT SUM(POPULATI..

https://www.hackerrank.com/challenges/revising-aggregations-the-count-function/problem?isFullScreen=true Revising Aggregations - The Count Function | HackerRank Query the number of cities having populations larger than 100000. www.hackerrank.com 문제 Query a count of the number of cities in CITY having a Population larger than . Input Format The CITY table is described as follows: Code SELECT COUN..

https://www.hackerrank.com/challenges/the-pads/problem?isFullScreen=true The PADS | HackerRank Query the name and abbreviated occupation for each person in OCCUPATIONS. www.hackerrank.com 문제 Generate the following two result sets: Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each profession as a parenthetical (i.e.: enclosed in par..

https://www.hackerrank.com/challenges/what-type-of-triangle/problem?isFullScreen=true Type of Triangle | HackerRank Query a triangle's type based on its side lengths. www.hackerrank.com 문제 Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output one of the following statements for each record in the table: Equilateral: It's a triangle with sid..

https://www.hackerrank.com/challenges/salary-of-employees/problem?isFullScreen=true Employee Salaries | HackerRank Print the names of employees who earn more than $2000 per month and have worked at the company for less than 10 months. www.hackerrank.com 문제 Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greater than per mont..