SELECT
    p.PF_CODE AS '都道府県コード',
    p.PF_NAME AS '都道府県名',
    ROUND(CAST(INP_YES as float) / (INP_YES + INP_NO + UNIDENTIFIED) * 100, 1) AS '入院率'
FROM
    HOSPITALIZATION AS h
LEFT JOIN
    PREFECTURE AS p
ON
    h.PF_CODE = p.PF_CODE
ORDER BY
    '都道府県' DESC,
    '都道府県コード'
;