Need help with SQL? Click here!
select hero_name, attack_range from hero where primary_attrib != 'int' and attack_range > 400
Due to MySQL limitations, 'order by' does not work. To get around this, just select your 'order by' as the first column. (NB: 'Order by' does work correctly with 'limit')