PokemonSqlLab/pokemon_sql/Part 4

-- strongest pokemon :
-- Salamence	Cooltrainer♂ Forgon	100	Dragon	Flying
-- because Salamence is a flying dragon!

select pok.name as "Pokemon Name",
       pt.trainername as "Trainer Name",
       t.pokelevel as "level",
       ptype.name as "primary type",
       stype.name as "secondary type"
from pokemon.trainers pt
left join pokemon.pokemon_trainer t
    on pt.trainerID = t.trainerID
left join pokemon.pokemons pok
    on pok.id = t.pokemon_id
left join pokemon.types ptype
    on pok.primary_type = ptype.id
left join pokemon.types stype
    on pok.secondary_type = stype.id
order by t.pokelevel desc , pok.secondary_type desc