select
  H.PF_CODE AS 都道府県コード, 
  P.PF_NAME AS 都道府県名,
  round((INP_YES * 1.0 / (INP_YES + INP_NO + UNIDENTIFIED) * 1.0) * 100.0, 1) AS 入院率
from HOSPITALIZATION H
LEFT JOIN PREFECTURE P ON H.PF_CODE = P.PF_CODE
ORDER BY 入院率 desc, H.PF_CODE