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.

Yet another ill-described problem. The minimum cost for each wand is the cost of the wand, right? join to filter evil ones and sort and we're done. Yet, my answer is "incorrect". As I encounter more and more poorly worded problems, the less interested in this site I become. :(

I understand the question i.e for each combination of age and power you need to find the wand with minimum cost that is not evil.

I came up with this:

SELECT MIN(w.coins_needed),w.power,wp.age from wands w
inner join wands_property wp
on w.code= wp.code
where wp.is_evil=0
group by w.power,wp.age
order by w.power desc, wp.age desc;

The solution requires me to add ID of the wand and I am struggling with the same.
Any Idea how to get the ID infront of my solution

## Ollivander's Inventory

You are viewing a single comment's thread. Return to all comments →

Yet another ill-described problem. The minimum cost for each wand is the cost of the wand, right? join to filter evil ones and sort and we're done. Yet, my answer is "incorrect". As I encounter more and more poorly worded problems, the less interested in this site I become. :(

There can be multiple wands of the same power and age but of different cost.

Yes, but the problem never mentioned to look for the minimum among the different combinations of power and age. It is ill-posed.

Finally I know why my code doesn't work... Thank you.

Can you (or someone else) help me?

I understand the question i.e for each combination of age and power you need to find the wand with minimum cost that is not evil.

I came up with this:

SELECT MIN(w.coins_needed),w.power,wp.age from wands w inner join wands_property wp on w.code= wp.code where wp.is_evil=0 group by w.power,wp.age order by w.power desc, wp.age desc;

The solution requires me to add ID of the wand and I am struggling with the same. Any Idea how to get the ID infront of my solution

Welcome to industry ;)

I agree. If the quality continues to be this uneven I'll abandon the site.