SELECT 
    HOSPITALIZATION.PF_CODE AS "都道府県コード",
    PREFECTURE.PF_NAME AS "都道府県名",
    round(round(cast(HOSPITALIZATION.INP_YES as REAL) / cast(HOSPITALIZATION.INP_YES+HOSPITALIZATION.INP_NO+HOSPITALIZATION.UNIDENTIFIED as REAL),3) * 100,1) AS "入院率"
FROM HOSPITALIZATION
INNER JOIN PREFECTURE ON HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
order by (round(round(cast(HOSPITALIZATION.INP_YES as REAL) / cast(HOSPITALIZATION.INP_YES+HOSPITALIZATION.INP_NO+HOSPITALIZATION.UNIDENTIFIED as REAL),3) * 100,1)) DESC,HOSPITALIZATION.PF_CODE DESC