We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Join
  4. Ollivander's Inventory
  5. Discussions

Ollivander's Inventory

Sort by

recency

|

2064 Discussions

|

  • floreaoana22
     + 0 comments

    SELECT w1.id, w2.age, w1.coins_needed, w1.power FROM Wands AS w1 JOIN Wands_Property AS w2 ON w1.code = w2.code WHERE w2.is_evil = 0 AND w1.coins_needed = ( SELECT MIN(a.coins_needed) FROM Wands AS a JOIN Wands_Property AS b ON a.code = b.code WHERE a.power = w1.power AND b.age = w2.age ) ORDER BY w1.power DESC, w2.age DESC;

  • nitika31
     + 0 comments

    II have seen a pattern that none of the window functions are running in hackerrank. Is this issue faced by someone else?

  • nitika31
     + 0 comments

    II have seen a pattern that none of the window functions are running in hackerrank. Is this issue faced by someone else?

  • iemrebatlicanci
     + 0 comments

    SELECT w.id, p.age, w.coins_needed, w.power FROM Wands w JOIN Wands_Property p ON w.code = p.code WHERE p.is_evil = 0 AND w.coins_needed = ( SELECT MIN(w1.coins_needed) FROM Wands w1 JOIN Wands_Property p1 ON w1.code = p1.code WHERE w1.power = w.power AND p1.age = p.age ) ORDER BY w.power DESC, p.age DESC;

  • frazali938
     + 0 comments
    Select Wands_Property.age,
Wands.code,
min(Wands.coins_needed) as MinCoinsNeeded,
Wands.power --min(Wands.coins_needed)
into #temp1
from Wands
join Wands_Property 
on Wands.code = Wands_Property.code and Wands_Property.is_evil = 0
group by Wands.power,Wands_Property.age,Wands.code


Select Wands.id,
#temp1.age,MinCoinsNeeded, #temp1.power
from #temp1
join Wands_Property on #temp1.age = Wands_Property.age
join Wands 
on wands.code = #temp1.code 
and #temp1.MinCoinsNeeded=Wands.coins_needed 
order by #temp1.power desc,#temp1.age desc