Hackerrank SQL Solutions | Ollivanders Inventory SQL Hackerrank Medium Problem

Veröffentlicht am: 13 April 2021
auf dem Kanal: The Coding Mentor

10,900

223

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

Auf dieser Seite können Sie das Online-Video Hackerrank SQL Solutions | Ollivanders Inventory SQL Hackerrank Medium Problem mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer The Coding Mentor 13 April 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 10,900 Mal angesehen und es wurde von 223 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

262