select 
	a.PF_CODE,
	b.PF_NAME,
	INP_YES as 入院,
	INP_YES + INP_NO + UNIDENTIFIED as 全体,
	round((INP_YES * 100) / round((INP_YES + INP_NO + UNIDENTIFIED),1),1) 
from 
	HOSPITALIZATION as a 
left join 
	PREFECTURE as b 
on
	a.PF_CODE = b.PF_CODE