select P.PF_CODE AS 都道府県コード
      ,P.PF_NAME AS 都道府県名
      ,round(
        cast(coalesce(INP_YES, 0) as real) / 
        cast((coalesce(INP_YES, 0) + coalesce(INP_NO, 0) + coalesce(UNIDENTIFIED, 0)) as real) * 100
        , 2)AS 入院率
  from PREFECTURE P
    inner join HOSPITALIZATION H
      on H.PF_CODE = P.PF_CODE
order by 入院率 DESC, 都道府県コード
;