select HOSPITALIZATION.PF_CODE as '都道府県コード'
        ,PF_NAME as '都道府県名'
        ,ROUND(cast(INP_YES as real)/(INP_YES+INP_NO+UNIDENTIFIED)*100,1) as '入院率' 
    from HOSPITALIZATION
    LEFT OUTER JOIN PREFECTURE
    on HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
    order by ROUND(cast(INP_YES as real)/(INP_YES+INP_NO+UNIDENTIFIED)*100,1) desc 
    ,HOSPITALIZATION.PF_CODE asc;