Ollivander’s Inventory MediumSQL (Intermediate) – HackerRank Solution SQL, Best and Optimal Solutions , All you need.
Solutions of SQL all HackerRank:
Here are all the Solutions of All of SQL of Hacker Rank , Leave a comment for similar posts
SQL Ollivander’s Inventory MediumSQL (Intermediate) HackerRank Solution
/*
Enter your query here.
*/
select
B.id,B.age,B.coins_needed,B.power
from
(select
Wands.power power,
Wands_Property.age age,
min(coins_needed) coins_needed
from
Wands left join Wands_Property on Wands.code = Wands_Property.code
where
Wands_Property.is_evil = 0
group by power,age) A
left join
(
select
Wands.id,
Wands.power power,
Wands_Property.age age,
Wands.coins_needed
from Wands left join Wands_Property on Wands.code = Wands_Property.code
where Wands_Property.is_evil = 0
) B
using(power,age,coins_needed)
order by
power desc,
age desc;
SQL (Basic)
SQL (Intermediate)
SQL (Advanced)
Basic Select
Advanced Select
Aggregation
Basic Join
Advanced Join
Alternative Queries
Leave a comment below