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