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