전체 글15 [SQL 코테 풀이] HackerRank - Placements (DIFFICULTY : Medium, SKILL : Intermediate, MySQL) 토요일이 밝았다! 어제 풀이로 정리한 내용을 가볍게 보니 Basic 12개 정도, Intermediate 8개 정도가 되는 것 같다. 오늘 하루도 화이팅 해보는 걸로 하자!! 오늘의 목표는 풀이를 찾아보지 않고 해결해내는 것! 문제 DIFFICULTY : Medium, SKILL : Intermediate, MySQL You are given three tables: Students, Friends and Packages. Students contains two columns: ID and Name. Friends contains two columns: ID and Friend_ID (ID of the ONLY best friend). Packages contains two columns: ID and .. 2024. 3. 23. [SQL 코테 풀이] HackerRank - Contest Leaderboard (DIFFICULTY : Medium, SKILL : Intermediate, MySQL) 난이도가 낮은 문제로 자신감을 채우고 나니 훨씬 낫다! 비록 여전히 영어 지문을 번역해서 풀고 있긴 하지만, 스스로 풀어냈다. 내일 아침부터 다시 문제를 지속적으로 풀어보면 더 익숙해지고 발전할 수 있겠다는 생각이 든다. 문제 DIFFICULTY : Medium, SKILL : Intermediate, MySQL You did such a great job helping Julia with her last coding contest challenge that she wants you to work on this one, too! The total score of a hacker is the sum of their maximum scores for all of the challenges. Write a q.. 2024. 3. 22. [SQL 코테 풀이] HackerRank - Weather Observation Station 1~12 (MySQL) 쉬운 문제부터 스스로! 빨리! 푸는거 오늘 남은 시간을 알차게 보내보자!! 시작~~~ Weather Observation Station 1 (DIFFICULTY : Easy, SKILL : Basic) Query a list of CITY and STATE from the STATION table. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. 문제해석 1) STATION 테이블에서 CITY, STATE를 조회하기 SELECT CITY, STATE FROM STATION ; Weather Observation Station 2 (DIFFICUL.. 2024. 3. 22. [SQL 코테 풀이] HackerRank - Weather Observation Station 19 (DIFFICULTY : Medium, SKILL : Basic, MySQL) 문제 DIFFICULTY : Medium, SKILL : Basic, MySQL Consider P1(a, c) and P2(b, d) to be two points on a 2D plane where (a, b) are the respective minimum and maximum values of Northern Latitude (LAT_N) and (c, d) are the respective minimum and maximum values of Western Longitude (LONG_W) in STATION. Query the Euclidean Distance between points P1 and P2 and format your answer to display 4 decimal digits.. 2024. 3. 22. 이전 1 2 3 4 다음
