코딩테스트/해커랭크 SQL44

• [해커랭크/MySQL] 45. Symmetric Pairs 👉https://www.hackerrank.com/challenges/symmetric-pairs/problem?isFullScreen=true Symmetric Pairs | HackerRank Write a query to output all symmetric pairs in ascending order by the value of X. www.hackerrank.com 🤔 문제 분석 1. Two pairs (X1, Y1) and (X2, Y2) are said to be symmetric pairs if X1 = Y2 and X2 = Y1. 2. Write a query to output all such symmetric pairs in ascending order by the value of X... 코딩테스트/해커랭크 SQL 2023. 4. 14.

• [해커랭크/MySQL] 44. Placements 👉https://www.hackerrank.com/challenges/placements/problem?isFullScreen=true Placements | HackerRank Write a query to output the names of those students whose best friends got offered a higher salary than them. www.hackerrank.com 🤔 문제 분석 1. There are 3 query. 2. Write a query to output the names of those students whose best friends got offered a higher salary than them. 3. Names must be ordered b.. 코딩테스트/해커랭크 SQL 2023. 4. 13.

• [해커랭크/MySQL] 43. Weather Observation Station 17 👉Weather Observation Station 17 | HackerRank Weather Observation Station 17 | HackerRank Query the Western Longitude for the smallest value of the Northern Latitudes greater than 38.7780 in STATION and round to 4 decimal places. www.hackerrank.com 🤔 문제 분석 1. Query the Western Longitude (LONG_W)where the smallest Northern Latitude (LAT_N) in STATION is greater than 38.7780. 2. Round your answer t.. 코딩테스트/해커랭크 SQL 2023. 4. 10.

• [해커랭크/MySQL] 42. Weather Observation Station 16 👉 https://www.hackerrank.com/challenges/weather-observation-station-16/problem?isFullScreen=true 🤔 문제 분석 1. Query the smallest Northern Latitude (LAT_N) from STATION that is greater than . 2. Round your answer to 4 decimal places. 💡 풀이 SELECT ROUND(MIN(LAT_N), 4) FROM STATION WHERE LAT_N > 38.7780 코딩테스트/해커랭크 SQL 2023. 4. 10.

• [해커랭크/MySQL] 41. Weather Observation Station 15 👉 https://www.hackerrank.com/challenges/weather-observation-station-15/problem?isFullScreen=true Weather Observation Station 15 | HackerRank Query the Western Longitude for the largest Northern Latitude under 137.2345, rounded to 4 decimal places. www.hackerrank.com 🤔 문제 분석 1. Query the Western Longitude (LONG_W) for the largest Northern Latitude (LAT_N) in STATION that is less than 137.2345. 2... 코딩테스트/해커랭크 SQL 2023. 3. 21.

• [해커랭크/MSSQL] 40. Ollivander's Inventory 👉 https://www.hackerrank.com/challenges/harry-potter-and-wands/problem?isFullScreen=true Ollivander's Inventory | HackerRank Help pick out Ron's new wand. www.hackerrank.com 🤔 문제 분석 1. Hermione decides the best way to choose is by determining the minimum number of gold galleons needed to buy each non-evil wand of high power and age. 2. Write a query to print the id, age, coins_needed, and power .. 코딩테스트/해커랭크 SQL 2023. 3. 21.

• [해커랭크/SQL] 39. Top Competitors 👉 https://www.hackerrank.com/challenges/full-score/problem?isFullScreen=true Top Competitors | HackerRank Query a list of top-scoring hackers. www.hackerrank.com 🤔 문제 분석 1. Write a query to print the respective hacker_id and name of hackers who achieved full scores for more than one challenge. 2. Order your output in descending order by the total number of challenges in which the hacker earned a.. 코딩테스트/해커랭크 SQL 2023. 3. 17.

• [해커랭크/SQL] 38. Contest Leaderboard 👉https://www.hackerrank.com/challenges/contest-leaderboard/problem?isFullScreen=true Contest Leaderboard | HackerRank Generate the contest leaderboard. www.hackerrank.com 🤔 문제 분석 1. You did such a great job helping Julia with her last coding contest challenge that she wants you to work on this one, too! 2. The total score of a hacker is the sum of their maximum scores for all of the challenges. .. 코딩테스트/해커랭크 SQL 2023. 3. 17.

• [해커랭크/SQL] 37. The Report 👉https://www.hackerrank.com/challenges/the-report/problem?isFullScreen=true The Report | HackerRank Write a query to generate a report containing three columns: Name, Grade and Mark. www.hackerrank.com 🤔 문제 분석 1. Ketty gives Eve a task to generate a report containing three columns: Name, Grade and Mark. 2. Ketty doesn't want the NAMES of those students who received a grade lower than 8. 3. The r.. 코딩테스트/해커랭크 SQL 2023. 3. 16.

• [해커랭크/SQL] 36. Weather Observation Station 18 👉https://www.hackerrank.com/challenges/weather-observation-station-18/problem?isFullScreen=true 🤔 문제 분석 Consider p1(a,b) and p2(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).. 코딩테스트/해커랭크 SQL 2023. 3. 16.

• [해커랭크/SQL] 35. Binary Tree Nodes 👉https://www.hackerrank.com/challenges/binary-search-tree-1/problem?isFullScreen=true Binary Tree Nodes | HackerRank Write a query to find the node type of BST ordered by the value of the node. www.hackerrank.com 🤔 문제 분석 1. 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. 2. Write a query to find the nod.. 코딩테스트/해커랭크 SQL 2023. 3. 14.

• [해커랭크/SQL] 34. Occupations(피봇테이블, 윈도우함수) 👉https://www.hackerrank.com/challenges/occupations/problem?isFullScreen=true Occupations | HackerRank Pivot the Occupation column so the Name of each person in OCCUPATIONS is displayed underneath their respective Occupation. www.hackerrank.com 🤔 문제 분석 1. Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. 2... 코딩테스트/해커랭크 SQL 2023. 3. 14.