select
	市区町村名,
	count(*) as 件数
from 郵便番号マスタ
group by 市区町村名
having count(*) >= 100
order by count(*) desc

select
	市区町村名,
	count(*) as 件数
from 郵便番号マスタ
group by 市区町村名
having count(*) >= 100
order by 件数 desc

select
	市区町村名,
	count(*) as 件数
from 郵便番号マスタ
group by 市区町村名
having 件数 >= 100
order by 件数 desc