SELECT
    H.PF_CODE as "都道府県コード",
    PF_NAME as "都道府県名",
    ROUND(CAST(INP_YES * 100 AS FLOAT) / (INP_YES + INP_NO + UNIDENTIFIED), 1) as RATIO
FROM 
HOSPITALIZATION as H INNER JOIN PREFECTURE as P 
ON
H.PF_CODE = P.PF_CODE
ORDER BY
RATIO DESC, H.PF_CODE
;