
SELECT generation.*, 
COUNT(pokemon.id_pokemon) as nombre_pokemon, 
SUM(pokemon.force) as total_force, 
MIN(YEAR(sortie)) as annee_premier_pokemon
FROM generation 
LEFT JOIN pokemon ON pokemon.id_generation = generation.id_generation
GROUP BY pokemon.id_generation
ORDER BY id_pokemon DESC

SUM(type='feu') as nombre_type_feu

SUM(choix='oui') as total_choix_oui

SUM(console_3ds) as nombre_console_3ds
