[해커랭크] MySQL 서브쿼리 - Top Competitors

[해커랭크] MySQL 서브쿼리 - Top Competitors

Top Competitors | HackerRankQuery a list of top-scoring hackers.www.hackerrank.com문제)Julia just finished conducting a coding contest, and she needs your help assembling the leaderboard! Write a query to print the respective hacker_id and name of hackers who achieved full scores for more than one challenge.Order your output in descending order by the total number of challenges in which the hacker..

  • format_list_bulleted SQL 스터디/HackerRank
  • · 2023. 9. 14.
  • textsms
[해커랭크] MySQL PERCENT_RANK - Weather Observation Station 20

[해커랭크] MySQL PERCENT_RANK - Weather Observation Station 20

Weather Observation Station 20 | HackerRank Query the median of Northern Latitudes in STATION and round to 4 decimal places. www.hackerrank.com LAT_N 값 중에서 중앙값(Median)을 찾는 문제입니다. 문제) A median is defined as a number separating the higher half of a data set from the lower half. Query the median of the Northern Latitudes (LAT_N) from STATION and round your answer to 4 decimal places. 이번 문제는 WINDOW ..

  • format_list_bulleted SQL 스터디/HackerRank
  • · 2023. 9. 14.
  • textsms
[해커랭크] MySQL JOIN - New Companies

[해커랭크] MySQL JOIN - New Companies

New Companies | HackerRank Find total number of employees. www.hackerrank.com 이번 문제는 JOIN과 계산함수를 활용하는 문제입니다. Amber's conglomerate corporation just acquired some new companies. Each of the companies follows this hierarchy: Given the table schemas below, write a query to print the company_code, founder name, total number of lead managers, total number of senior managers, total number of managers, ..

  • format_list_bulleted SQL 스터디/HackerRank
  • · 2023. 9. 12.
  • textsms
[해커랭크] MySQL - Binary Tree Nodes

[해커랭크] MySQL - Binary Tree Nodes

Binary Tree Nodes | HackerRank Write a query to find the node type of BST ordered by the value of the node. www.hackerrank.com 이번 문제는 이진 트리와 관련된 문제를 푸는 쿼리입니다. 문제) 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. Write a query to find the node type of Binary Tree ordered by the value of the node. Output o..

  • format_list_bulleted SQL 스터디/HackerRank
  • · 2023. 9. 12.
  • textsms
[해커랭크] MySQL TRNCATE 함수 - Weather Observation Station 14

[해커랭크] MySQL TRNCATE 함수 - Weather Observation Station 14

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 137.2345 보다 낮은 북위도 중 가장 큰 값을 찾는 쿼리를 출력하는 문제입니다. 문제) Query the greatest value of the Northern Latitudes (LAT_N) from STATION that is less than 137.2345. Truncate your answer to decimal places. 그리고 소수점을 4자리 밑으로는 제외..

  • format_list_bulleted SQL 스터디/HackerRank
  • · 2023. 9. 11.
  • textsms
[해커랭크] MySQL WHERE절 서브쿼리 - Top Earners

[해커랭크] MySQL WHERE절 서브쿼리 - Top Earners

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 이번 문제는 그 동안 급여를 가장 많이 받은 급여의 금액과 몇 명이 받았는지 출력하는 문제입니다. 총 급여는 salary x month로 정의하고 (각 직원의 급여와 재직 개월 수) 총 급여를 구합니다. 문제) We define an employee's total earnings to be their monthly salary x months worked, and the maximum total..

  • format_list_bulleted 카테고리 없음
  • · 2023. 9. 11.
  • textsms