all distinct Pokémon catch rates (in X/Y)

catch-rate.txt

 rate | count |  example   
------+-------+------------
    3 |    45 | articuno
    5 |     2 | kyogre
   15 |     1 | volcarona
   25 |    10 | clefable
   30 |    21 | chansey
   35 |     1 | ditto
   45 |   224 | bulbasaur
   50 |     7 | wigglytuff
   55 |     3 | dragalge
   60 |    44 | tentacruel
   65 |     3 | sudowoodo
   70 |     1 | slowking
   75 |    57 | raichu
   80 |     1 | malamar
   90 |    36 | fearow
  100 |     5 | kadabra
  120 |    51 | metapod
  125 |     3 | wailmer
  127 |     4 | raticate
  130 |     2 | happiny
  140 |     4 | hippopotas
  145 |     1 | mime-jr
  150 |     7 | clefairy
  155 |     1 | crawdaunt
  160 |     1 | furfrou
  170 |     2 | jigglypuff
  180 |    10 | machop
  190 |    69 | pikachu
  200 |    18 | abra
  205 |     1 | corphish
  220 |     2 | litleo
  225 |    14 | krabby
  235 |     6 | nidoran-f
  255 |    64 | caterpie
(34 rows)

query.sql

with r as (
    select capture_rate "rate", min(id) "id", count(*) "count"
    from pokemon_species
    group by capture_rate
)

select r.rate, r.count, p.identifier "example"
from r
join pokemon_species p on r.id=p.id
order by r.rate;