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.
select A.id, B.age, A.coins_needed, A.power
FROM Wands A
JOIN Wands_Property B ON A.code = B.Code
JOIN
(
SELECT C.code, C.power , MIN(C.coins_needed) AS coins
FROM Wands C
JOIN Wands_Property D ON C.code = D.code
WHERE D.is_evil = 0
Group By D.age, C.power
) AS filtered
ON A.code = filtered.code AND A.coins_needed = filtered.coins AND A.power = filtered.power
Order By A.power DESC, B.age DESC, A.coins_needed ASC
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Ollivander's Inventory
You are viewing a single comment's thread. Return to all comments →
select A.id, B.age, A.coins_needed, A.power FROM Wands A JOIN Wands_Property B ON A.code = B.Code JOIN ( SELECT C.code, C.power , MIN(C.coins_needed) AS coins FROM Wands C JOIN Wands_Property D ON C.code = D.code WHERE D.is_evil = 0 Group By D.age, C.power ) AS filtered ON A.code = filtered.code AND A.coins_needed = filtered.coins AND A.power = filtered.power Order By A.power DESC, B.age DESC, A.coins_needed ASC