SELECT P.PF_CODE AS '都道府県コード', 
       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 PREFECTURE AS P
JOIN HOSPITALIZATION AS H
ON P.PF_CODE = H.PF_CODE
ORDER BY 入院率 DESC, P.PF_CODE ASC;