문제풀이/SQL(My sql)95 [문제풀이] Hacker Rank - THE REPORT 출처 The Report | HackerRankWrite a query to generate a report containing three columns: Name, Grade and Mark.www.hackerrank.com 문제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 report must be in descending order by grade -- i.e. higher grades are entered first. If th.. 2024. 6. 11. [문제풀이] Hacker Rank - Weather Observation Station 20 출처 Weather Observation Station 20 | HackerRankQuery the median of Northern Latitudes in STATION and round to 4 decimal places.www.hackerrank.com 문제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 decimal places 4. Input Format 문제에 대한 해석LAT_N의 중간값을 4쨰자리까지 표현하라중간값 .. 2024. 6. 10. [문제풀이] Hacker Rank - Binary Tree Nodes 출처 Binary Tree Nodes | HackerRankWrite 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 one of the following for each node:.. 2024. 6. 10. [문제풀이] Hacker Rank - Weather Observation Station 18, 19 출처문제 18Consider p1(a,b) and 소2(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).d happens to equal the maximum value in Western Longitude (LONG_W in STATION).Query the Manhattan .. 2024. 6. 8. [문제풀이] Hacker Rank - Weather Observation Station 17 출처 문제Query the Western Longitude (LONG_W)where the smallest Northern Latitude (LAT_N) in STATION is greater than 38.7780 Round your answer to decima 4 places. 문제에 대한 해석조건 : LAT_N가 38.7780보다 큰 것중에 가장 작은 경우의 조회 : LONG_W(반올림하여 소수점 4자리까지) 풀이(MYSQL)-- 정답1. 38.7780조건 > 정렬 > limitSELECT ROUND(LONG_W,4)FROM STATIONWHERE LAT_N> 38.7788ORDER BY LAT_NLIMIT 1-- 정답2. 38.7780조건에 충족하는 테이블 > 최솟값 조건 with tm.. 2024. 6. 7. [문제풀이] Hacker Rank - The Blunder 출처 문제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), and the actual average salary.Write a query calculating the amount of error, and r.. 2024. 6. 7. 이전 1 ··· 6 7 8 9 10 11 12 ··· 16 다음
