--select a.PF_CODE as 都道府県コード, a.PF_NAME as 都道府県名, CAST(ROUND(CAST(INP_YES as float)/(INP_YES+INP_NO+UNIDENTIFIED)*100 ,2) as decimal(5,1) )as 入院率 from PREFECTURE a inner join HOSPITALIZATION b on a.PF_CODE=b.PF_CODE;
select a.PF_CODE as 都道府県コード, a.PF_NAME as 都道府県名, CAST(ROUND(CAST(INP_YES as real)/(INP_YES+INP_NO+UNIDENTIFIED)*100,1) as numeric) as 入院率 from PREFECTURE a inner join HOSPITALIZATION b on a.PF_CODE=b.PF_CODE;