Frosty Friday’s super academy wants to know who their best and worst super heroes are, and the only metric that matters is villains defeated. Using MIN_BY and MAX_BY, tell us which super hero is the best, and which is the worst.
create or replace table w31(id int, hero_name string, villains_defeated number); insert into w31 values (1, 'Pigman', 5), (2, 'The OX', 10), (3, 'Zaranine', 4), (4, 'Frostus', 8), (5, 'Fridayus', 1), (6, 'SheFrost', 13), (7, 'Dezzin', 2.3), (8, 'Orn', 7), (9, 'Killder', 6), (10, 'PolarBeast', 11) ;
Your end result should look something like this:
Remember, if you want to participate:
Thanks for using this platform to promote new functionality!
Jamie Laird says
Here’s my solution
Neat! Useful new functions
Pretty easy one this time.