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