select P.PF_CODE as 都道府県コード,
    P.PF_NAME as 都道府県名,
    ROUND(CAST(H.INP_YES as REAL)/CAST(H.INP_YES+H.INP_NO+H.UNIDENTIFIED as REAL)*100,1) as 入院率
from HOSPITALIZATION as H inner join PREFECTURE as P
where H.PF_CODE=P.PF_CODE
order by 入院率 desc, 都道府県コード asc;