Need help with SQL? Click here!
select attack_range, hero_name from hero where attack_range > 500 and primary_attrib != 'int'
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')