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