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