코딩테스트151

• [해커랭크/SQL] 27. Population Density Difference 👉 https://www.hackerrank.com/challenges/population-density-difference/problem?isFullScreen=true&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Population Density Difference | HackerRank Query the difference between the maximum and minimum city populations in CITY. www.hackerrank.com 🤔 문제 분석 1) Query the difference between the maximum and minimum populations in CITY. 💡 풀이 SELECT MAX(POPULA.. 코딩테스트/해커랭크 SQL 2023. 3. 7.

• [해커랭크/SQL] 26. Japan Population 👉 https://www.hackerrank.com/challenges/japan-population/problem?isFullScreen=true&h_r=next-challenge&h_v=zen Japan Population | HackerRank Query to the sum of the populations of all Japanese cities in CITY. www.hackerrank.com 🤔 문제 분석 1) Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN. 💡 풀이 SELECT SUM(POPULATION) FROM CITY WHERE COUNTRYCODE = "J.. 코딩테스트/해커랭크 SQL 2023. 3. 7.

• [해커랭크/SQL] 25. Average Population 👉 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 🤔 문제 분석 1) Query the average population for all cities in CITY, rounded down to the nearest integer. 💡 풀이 SELECT ROUND(AVG(POPULATION), 0) FROM CITY 코딩테스트/해커랭크 SQL 2023. 3. 7.

• [해커랭크/SQL] 24. Revising Aggregations - Averages 👉 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 🤔 문제 분석 1) Query the average population of all cities in CITY where District is California. 💡 풀이 SELECT AVG(POPULATION) FROM CITY WHERE DISTRICT = "Ca.. 코딩테스트/해커랭크 SQL 2023. 3. 6.

• [해커랭크/SQL] 23. Revising Aggregations - The Sum Function 👉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 🤔 문제 분석 1) Query the total population of all cities in CITY where District is California. 💡 풀이 SELECT SUM(POPULATION) FROM CITY WHERE DISTRICT = "California" 코딩테스트/해커랭크 SQL 2023. 3. 6.

• [해커랭크/SQL] 22. Revising Aggregations - The Count Function 👉 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 🤔 문제 분석 1) Query a count of the number of cities in CITY having a Population larger than 100000. 💡 풀이 SELECT COUNT(DISTINCT NAME) FROM CITY WHERE POPU.. 코딩테스트/해커랭크 SQL 2023. 3. 6.

• [해커랭크/SQL] 20. Employee Salaries 👉 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 🤔 문제 분석 1) Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greater tha.. 코딩테스트/해커랭크 SQL 2023. 2. 22.

• [해커랭크/SQL] 19. Employee Names 👉 https://www.hackerrank.com/challenges/name-of-employees/problem?isFullScreen=true Employee Names | HackerRank Print employee names. www.hackerrank.com 🤔 문제 분석 1) Write a query that prints a list of employee names (i.e.: the name attribute) from the Employee table in alphabetical order. 💡 풀이 SELECT name FROM Employee ORDER BY name 코딩테스트/해커랭크 SQL 2023. 2. 22.

• [해커랭크/SQL] 18. Higher Than 75 Marks 👉 https://www.hackerrank.com/challenges/more-than-75-marks/problem?isFullScreen=true Higher Than 75 Marks | HackerRank Query the names of students scoring higher than 75 Marks. Sort the output by the LAST three characters of each name. www.hackerrank.com 🤔 문제 분석 1) Query the Name of any student in STUDENTS who scored higher than Marks. 2) Order your output by the last three characters of each na.. 코딩테스트/해커랭크 SQL 2023. 2. 22.

• [해커랭크/SQL] 17. Weather Observation Station 12 (REGEXP) 👉 https://www.hackerrank.com/challenges/weather-observation-station-12/problem?isFullScreen=true&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Weather Observation Station 12 | HackerRank Query an alphabetically ordered list of CITY names not starting and ending with vowels. www.hackerrank.com 🤔 문제 분석 1) Query the list of CITY names from STATION that do not start with vowels and do not en.. 코딩테스트/해커랭크 SQL 2023. 2. 21.

• [해커랭크/SQL] 16. Weather Observation Station 11 (REGEXP) 👉 https://www.hackerrank.com/challenges/weather-observation-station-11/problem?isFullScreen=true&h_r=next-challenge&h_v=zen Weather Observation Station 11 | HackerRank Query a list of CITY names not starting or ending with vowels. www.hackerrank.com 🤔 문제 분석 1) Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. 2) Your result cannot contain d.. 코딩테스트/해커랭크 SQL 2023. 2. 21.

• [해커랭크/SQL] 15. Weather Observation Station 10 (REGEXP) 👉 https://www.hackerrank.com/challenges/weather-observation-station-10/problem?isFullScreen=true Weather Observation Station 10 | HackerRank Query a list of CITY names not ending in vowels. www.hackerrank.com 🤔 문제 분석 1) Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates. 💡 풀이 SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP "[^a|e|i|o|.. 코딩테스트/해커랭크 SQL 2023. 2. 21.