문제링크 : https://www.hackerrank.com/challenges/full-score/problem?isFullScreen=true ❓문제 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 hack..

문제링크 : https://www.hackerrank.com/challenges/the-report/problem?isFullScreen=true ❓문제 You are given two tables: Students and Grades. Students contains three columns ID, Name and Marks. Grades contains the following data: Ketty gives Eve a task to generate a report containing three columns: Name, Grade and Mark. Ketty doesn't want the NAMES of those students who received a grade lower than 8. The..

문제링크 : https://www.hackerrank.com/challenges/weather-observation-station-20/problem?isFullScreen=true ❓문제 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. Input Format The STATION table is described as follows: where LAT_N is the northern latitud..

문제링크 : https://www.hackerrank.com/challenges/the-company/problem?isFullScreen=true ❓문제 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, and total number of em..

문제링크 : https://www.hackerrank.com/challenges/binary-search-tree-1/problem?isFullScreen=true ❓문제 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 one of the following for each node: Root: If node is root node. Leaf..

문제링크 : https://www.hackerrank.com/challenges/earnings-of-employees/problem?isFullScreen=true ❓문제 We define an employee's total earnings to be their monthly salray x months worked, and the maximum total earnings to be the maximum total earnings for any employee in the Employee table. Write a query to find the maximum total earnings for all employees as well as the total number of employees who ha..

문제링크 : https://www.hackerrank.com/challenges/the-blunder/problem?isFullScreen=true ❓문제 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 calculation. She wants your help finding the difference between her miscalculation (using salaries with any zeros removed), ..

문제링크 : https://www.hackerrank.com/challenges/population-density-difference?isFullScreen=true ❓문제 Query the difference between the maximum and minimum populations in CITY. Input Format The CITY table is described as follows: 🔉 문제 설명 인구수의 최대와 최소의 차를 쿼 ❗답 SELECT MAX(POPULATION) - MIN(POPULATION) FROM CITY 🤔풀이