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