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.
- Prepare
- SQL
- Basic Join
- Ollivander's Inventory
- Discussions
Ollivander's Inventory
Ollivander's Inventory
Sort by
recency
|
1655 Discussions
|
Please Login in order to post a comment
can somebody identify where is the issue in below sql server submission i am not able to understand why it is not passing
select id, age, coins_needed, power from wands w join wands_property wp on w.code = wp.code where coins_needed in ( select min(coins_needed) from wands w join wands_property wp on w.code = wp.code where is_evil = 0 group by w.code, age, power ) order by power desc, age desc;
ORACLE
MySQL: