SELECT  a.pokemon_name, a.name, a.type, a.damage, a.desc
FROM    Attack a
        INNER JOIN
        (
            SELECT  type, MAX(damage) MaxD
            FROM Attack 
            GROUP BY Type 
        ) b ON a.Type = b.Type AND
                a.damage = b.MaxD
WHERE a.type!="none"
SELECT was, gonna_be
FROM evolves
WHERE i_am = "dragonair