SELECT p.PF_CODE AS '都道府県コード',p.PF_NAME AS '都道府県名', ROUND(100.0*h.INP_YES/(h.INP_YES+h.INP_NO+h.UNIDENTIFIED) ,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;