SELECT 
A.PF_CODE AS "都道府県コード"
,B.PF_NAME AS "都道府県名"
,round((cast(INP_YES AS REAL)/cast((INP_YES+INP_NO+UNIDENTIFIED) AS REAL))*100,1) AS "入院率"
FROM HOSPITALIZATION A
INNER JOIN PREFECTURE  B
ON A.PF_CODE=B.PF_CODE
order by 3 DESC,1 ASC