select
HOSPITALIZATION.PF_CODE
,PF_NAME
,round (cast(INP_YES as real) / cast((INP_YES+INP_NO + UNIDENTIFIED) as real)*100,1) as 入院率
,INP_NO
,UNIDENTIFIED
from HOSPITALIZATION
inner join PREFECTURE
on HOSPITALIZATION.PF_CODE=PREFECTURE.PF_CODE