분류 전체보기107 HackerRank 공부 4 https://www.hackerrank.com/challenges/full-score/problem Top Competitors | HackerRank Query a list of top-scoring hackers. www.hackerrank.com 문제 핵심 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 earned a full score. If more than on.. 2023. 3. 9. HackerRank 공부 3 https://www.hackerrank.com/challenges/the-report/problem The Report | HackerRank Write a query to generate a report containing three columns: Name, Grade and Mark. www.hackerrank.com Sample Input Sample Output Maria 10 99 Jane 9 81 Julia 9 88 Scarlet 8 78 NULL 7 63 NULL 7 68 Note Print "NULL" as the name if the grade is less than 8. 문제 핵심 1. case when으로 컬럼 생성하기 2. null값 생성하기 3. join 할 때 컬럼 betwe.. 2023. 3. 6. HackerRank 공부 2 https://www.hackerrank.com/challenges/what-type-of-triangle/problem Type of Triangle | HackerRank Query a triangle's type based on its side lengths. www.hackerrank.com Sample Input Sample Output Isosceles Equilateral Scalene Not A Triangle 문제 핵심 1. case when 활용해서 컬럼 생성하기 2. case when 순서를 활용해서 집합 관계로 컬럼 생성하기 내 풀이 SELECT CASE WHEN A + B 2023. 3. 6. HackerRank 공부 1 https://www.hackerrank.com/challenges/the-pads/problem The PADS | HackerRank Query the name and abbreviated occupation for each person in OCCUPATIONS. www.hackerrank.com 문제 핵심 Ashely(P) Christeen(P) Jane(A) Jenny(D) Julia(A) Ketty(P) Maria(A) Meera(S) Priya(S) Samantha(D) There are a total of 2 doctors. There are a total of 2 singers. There are a total of 3 actors. There are a total of 3 profess.. 2023. 3. 6. 이전 1 2 3 4 5 ··· 27 다음
