PokemonSqlLab/Part 4

# Sort the data by finding out which trainer has the strongest pokemon so
# that this will act as a ranking of strongest to weakest trainer.
# You may interpret strongest in whatever way you want, but you will have to explain your decision.
SELECT pokemon.pokemons.name,
       pokemon.trainers.trainername,
       pokemon.pokemon_trainer.pokelevel,
       pokemon.pokemons.primary_type,
       pokemon.pokemons.secondary_type
FROM pokemon.pokemons,
     pokemon.trainers,
     pokemon.pokemon_trainer
WHERE pokemon.pokemons.id = pokemon.pokemon_trainer.pokemon_id
  AND pokemon.pokemon_trainer.trainerID = pokemon.trainers.trainerID
ORDER BY ((attack + defense + spatk + spdef + speed + hp) * pokelevel) DESC;
# Strongest Pokemon was determined by adding the attack, defense, spatk, spdef, speed and hp.
# Then multiplying the sum by the pokelevel.