select distinct spawnpoint_id, count(distinct pokemon_id) as unique_pokemon, count(*) as spawn_count, latitude, longitude from pokemon where pokemon_id not in (16, 19, 46, 133, 48) group by spawnpoint_id order by 3 desc;
select distinct spawnpoint_id, count(distinct pokemon_id) as unique_pokemon, count(*) as spawn_count, latitude, longitude from pokemon where pokemon_id not in (16, 19, 46, 133, 48) group by spawnpoint_id order by 3 desc;
Comments
0 B
|👍
/👎