코딩테스트151

• [해커랭크/SQL] 38. Contest Leaderboard 👉https://www.hackerrank.com/challenges/contest-leaderboard/problem?isFullScreen=true Contest Leaderboard | HackerRank Generate the contest leaderboard. www.hackerrank.com 🤔 문제 분석 1. You did such a great job helping Julia with her last coding contest challenge that she wants you to work on this one, too! 2. The total score of a hacker is the sum of their maximum scores for all of the challenges. .. 코딩테스트/해커랭크 SQL 2023. 3. 17.

• [해커랭크/SQL] 37. The Report 👉https://www.hackerrank.com/challenges/the-report/problem?isFullScreen=true The Report | HackerRank Write a query to generate a report containing three columns: Name, Grade and Mark. www.hackerrank.com 🤔 문제 분석 1. Ketty gives Eve a task to generate a report containing three columns: Name, Grade and Mark. 2. Ketty doesn't want the NAMES of those students who received a grade lower than 8. 3. The r.. 코딩테스트/해커랭크 SQL 2023. 3. 16.

• [해커랭크/SQL] 36. Weather Observation Station 18 👉https://www.hackerrank.com/challenges/weather-observation-station-18/problem?isFullScreen=true 🤔 문제 분석 Consider p1(a,b) and p2(c,d) to be two points on a 2D plane. a happens to equal the minimum value in Northern Latitude (LAT_N in STATION). b happens to equal the minimum value in Western Longitude (LONG_W in STATION). c happens to equal the maximum value in Northern Latitude (LAT_N in STATION).. 코딩테스트/해커랭크 SQL 2023. 3. 16.

• [해커랭크/SQL] 35. Binary Tree Nodes 👉https://www.hackerrank.com/challenges/binary-search-tree-1/problem?isFullScreen=true Binary Tree Nodes | HackerRank Write a query to find the node type of BST ordered by the value of the node. www.hackerrank.com 🤔 문제 분석 1. You are given a table, BST, containing two columns: N and P, where N represents the value of a node in Binary Tree, and P is the parent of N. 2. Write a query to find the nod.. 코딩테스트/해커랭크 SQL 2023. 3. 14.

• [해커랭크/SQL] 34. Occupations(피봇테이블, 윈도우함수) 👉https://www.hackerrank.com/challenges/occupations/problem?isFullScreen=true Occupations | HackerRank Pivot the Occupation column so the Name of each person in OCCUPATIONS is displayed underneath their respective Occupation. www.hackerrank.com 🤔 문제 분석 1. Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. 2... 코딩테스트/해커랭크 SQL 2023. 3. 14.

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

• 1. 코딩테스트 준비하기(시간복잡도, 디버깅) Do it! 알고리즘 코딩테스트 파이썬편 교재와 하루코딩 님의 Do it! 알고리즘 코딩테스트 유튜브 강의를 바탕으로 정리한 내용입니다. 유튜브: https://www.youtube.com/@codingtest 1. 시간복잡도 시간복잡도는 알고리즘 선택 기준이 될 수 잇음 1️⃣ 시간복잡도란 주어진 문제를 해결하기 위한 연산 횟수 2️⃣ 시간 복잡도 유형 빅오메가: 최선일 때의 연산 횟수를 나타낸 표기법 빅세타: 보통일 때의 연산 횟수를 나타낸 표기법 빅오: 최악일 대의 연산 횟수를 나타낸 표기법 코딩 테스트에서는 빅오 표기법을 기준으로 수행시간을 계산하는 것이 좋다. 즉, 빅오 상황에서의 연산횟수를 기준으로 알고리즘 적합도를 판별할 줄 알아야 한다. (연산횟수 = 알고리즘 시간 복잡도 n값에 데이터의 .. 코딩테스트/알고리즘 이론 2023. 3. 7.