SELECT
    H.PF_CODE '都道府県コード',
    PF_NAME '都道府県名',
    ROUND(
        IFNULL(INP_YES,0)*100.0
        /
        (IFNULL(INP_YES,0)+IFNULL(INP_NO,0)+IFNULL(UNIDENTIFIED,0)),1) '入院率'
FROM 
    HOSPITALIZATION H
    INNER JOIN PREFECTURE R ON H.PF_CODE = R.PF_CODE
ORDER BY
    入院率 DESC,
    H.PF_CODE ASC