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