Skip to content

Latest commit

 

History

History
27 lines (20 loc) · 852 Bytes

SQL-with-Pokemon-Damage-Multipliers.md

File metadata and controls

27 lines (20 loc) · 852 Bytes
Raw

You have arrived at the Celadon Gym to battle Erika for the Rainbow Badge.

She will be using Grass-type Pokemon. Any fire pokemon you have will be strong against grass, but your water types will be weakened. The multipliers table within your Pokedex will take care of that.

Using the following tables, return the pokemon_name, modifiedStrength and element of the Pokemon whose strength, after taking these changes into account, is greater than or equal to 40, ordered from strongest to weakest.

pokemon schema

  • id

  • pokemon_name

  • element_id

  • str multipliers schema

  • id

  • element

  • multiplier

-- i choose you! --

SELECT p.pokemon_name, p.str * m.multiplier as modifiedStrength, m.element 
FROM pokemon as p 
JOIN multipliers as m ON p.element_id = m.id 
WHERE p.str * m.multiplier >= 40
ORDER BY modifiedStrength DESC