select
		to_char(num1, 'FM000-') || to_char(num2, 'FM0000') as 郵便番号,
		count(*) as 重複件数
	from zipcode
	group by num1, num2
	having count(*) >= 10
	order by count(*) desc
;