select
PREFECTURE.PF_CODE as  都道府県コード,	PREFECTURE.PF_NAME as 都道府県名,b.入院率
from 
(select PF_CODE, round(cast(INP_YES as REAL) / (cast(INP_YES as REAL) + cast(INP_NO as REAL) + cast(UNIDENTIFIED as REAL)) * 100,1) as  入院率 from HOSPITALIZATION
 ) as b
inner join PREFECTURE on PREFECTURE.PF_CODE = b.PF_CODE
order by PREFECTURE.PF_CODE