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