[lmikle]

Как-то так:

Код:

select club_No, place, count(place)
from Your_table
group by club_No, place