코딩테스트/해커랭크 SQL44

• [해커랭크/SQL] 33. Weather Observation Station 14 👉https://www.hackerrank.com/challenges/weather-observation-station-14/problem?isFullScreen=true Weather Observation Station 14 | HackerRank Query the greatest value of the Northern Latitudes from STATION that are under 137.2345 and truncated to 4 decimal places. www.hackerrank.com 🤔 문제 분석 1. Query the greatest value of the Northern Latitudes (LAT_N) from STATION that is less than 137.2345. 2. Tr.. 코딩테스트/해커랭크 SQL 2023. 3. 13.

• [해커랭크/SQL] 32. The PADS (concat, 문자열 합치기) 👉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 🤔 문제 분석 1. 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 parentheses). For example: AnActor.. 코딩테스트/해커랭크 SQL 2023. 3. 13.

• [해커랭크/SQL] 31. Weather Observation Station 13 👉https://www.hackerrank.com/challenges/weather-observation-station-13/problem?isFullScreen=true Weather Observation Station 13 | HackerRank Query the sum of Northern Latitudes having values greater than 38.7880 and less than 137.2345, truncated to 4 decimal places. www.hackerrank.com 🤔 문제 분석 Query the sum of Northern Latitudes (LAT_N) from STATION having values greater than 38.7880 and less than.. 코딩테스트/해커랭크 SQL 2023. 3. 12.

• [해커랭크/SQL] 30. Weather Observation Station 2 👉https://www.hackerrank.com/challenges/weather-observation-station-2/problem?isFullScreen=true Weather Observation Station 2 | HackerRank Write a query to print the sum of LAT_N and the sum of LONG_W separated by space, rounded to 2 decimal places. www.hackerrank.com 🤔 문제 분석 Query the following two values from the STATION table: The sum of all values in LAT_N rounded to a scale of 2 decimal plac.. 코딩테스트/해커랭크 SQL 2023. 3. 12.

• [해커랭크/SQL] 29. Top Earners 👉https://www.hackerrank.com/challenges/earnings-of-employees/problem?isFullScreen=true Top Earners | HackerRank Find the maximum amount of money earned by any employee, as well as the number of top earners (people who have earned this amount). www.hackerrank.com 🤔 문제 분석 1) Write a query to find the maximum total earnings for all employees 2) as well as the total number of employees who have maxi.. 코딩테스트/해커랭크 SQL 2023. 3. 8.

• [해커랭크/SQL] 28. The Blunder - replace 함수 👉https://www.hackerrank.com/challenges/the-blunder/problem?isFullScreen=true The Blunder | HackerRank Query the amount of error in Sam's result, rounded up to the next integer. www.hackerrank.com 🤔 문제 분석 1) Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's 0 key was broken until after completing the calc.. 코딩테스트/해커랭크 SQL 2023. 3. 8.

• [해커랭크/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.