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
In questa pagina del sito puoi guardare il video online Hackerrank SQL Solutions | Ollivanders Inventory SQL Hackerrank Medium Problem della durata di ore minuti seconda in buona qualità , che l'utente ha caricato The Coding Mentor 13 aprile 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 10,900 volte e gli è piaciuto 223 spettatori. Buona visione!
