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 PREFECTURE as p
    JOIN HOSPITALIZATION as h ON p.PF_CODE = h.PF_CODE
    ORDER BY ROUND(cast(h.INP_YES as REAL) / cast(h.INP_YES + h.INP_NO + h.UNIDENTIFIED as REAL) * 100, 1) DESC, p.PF_CODE ASC
;