SELECT P.PF_CODE AS "都道府県コード", P.PF_NAME AS "都道府県名", ROUND(H.INP_YES*100/(H.INP_YES+H.INP_NO+UNIDENTIFIED)) AS "入院率"
FROM PREFECTURE AS P INNER JOIN HOSPITALIZATION AS H ON H.PF_CODE = P.PF_CODE ORDER BY "入院率" DESC;