-- SQLite
SELECT
    P.PF_CODE as "都道府県コード",
    P.PF_NAME as "都道府県名",
    ROUND(H.INP_YES * 100.0 / (H.INP_YES + H.INP_NO + H.UNIDENTIFIED), 1) as "入院率"
FROM PREFECTURE P
LEFT JOIN HOSPITALIZATION H ON P.PF_CODE = H.PF_CODE
ORDER BY
    "入院率" DESC,
    "都道府県コード"
;