목록MySQL (43)

Milky's note

[HackerRank](M) 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 [문제] You are given a table, Functions, containing two columns: X and Y. Two pairs (X1, Y1) and (X2, Y2) are said to be symmetric pairs if X1 = Y2 and X2 = Y1. Write a query to output all s..
SQL/SQL 코딩 테스트-HackerRank 2022. 4. 6. 15:36
[HackerRank](M) Print Prime Numbers

https://www.hackerrank.com/challenges/print-prime-numbers/problem?isFullScreen=true Print Prime Numbers | HackerRank Print prime numbers. www.hackerrank.com [문제] Write a query to print all prime numbers less than or equal to 1000. Print your result on a single line, and use the ampersand (&) character as your separator (instead of a space). For example, the output for all prime numbers
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 31. 18:05
[HackerRank](M) 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 [문제] 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..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 31. 16:35
[HackerRank](M) 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 [문제] 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 ONL..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 31. 15:33
Prev 1 2 3 4 ··· 11 Next