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
On this page of the site you can watch the video online Hackerrank SQL Solutions | Ollivanders Inventory SQL Hackerrank Medium Problem with a duration of hours minute second in good quality, which was uploaded by the user The Coding Mentor 13 April 2021, share the link with friends and acquaintances, this video has already been watched 10,900 times on youtube and it was liked by 223 viewers. Enjoy your viewing!
