Hackerrank SQL Solutions | Ollivanders Inventory SQL Hackerrank Medium Problem
In this video we are solving "Ollivanders Inventory". This is a Medium SQL Problem on Hackerrank.
____________________________________________
SUBSCRIBE!
Do you want to understand how to solve SQL Problems in every detail? That's what my channel is about. When I was younger I thought I could never program because it looked way too difficult. The truth is that it takes time but with some patience anybody can do it! Follow me along and get better!
____________________________________________
SUPPORT MY CHANNEL
🙌The best way to support my channel right now is to give me a Super Thanks. You can do that by clicking thanks next to the title of the video. It is much appreciated!
____________________________________________
💾GitHub: https://github.com/CuriosityLeonardo?...
✋Add me on LinkedIn to get in contact: / markus-fr. .
____________________________________________
0:00 Problem Description
0:55 Output Requirements
2:50 Code Age Relationship
4:38 Manual Solution
8:04 Start Query
10:27 Wands Table
11:08 Row Number Explanation
18:38 JOIN Wands and Wands_Property
Code:
WITH min_coins as (
SELECT
ROW_NUMBER() OVER(PARTITION BY code,power ORDER BY coins_needed asc) as RowNumber,
id,
code,
coins_needed,
power
FROM Wands
)
SELECT
id,
age,
coins_needed,
power
FROM Wands_Property wp
JOIN min_coins mc ON mc.code = wp.code AND RowNumber = 1
WHERE is_evil = 0
ORDER BY power desc, age desc
Nesta página do site você pode assistir ao vídeo on-line Hackerrank SQL Solutions | Ollivanders Inventory SQL Hackerrank Medium Problem duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário The Coding Mentor 13 Abril 2021, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 10,900 vezes e gostou 223 espectadores. Boa visualização!
