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, 1) AS 入院率
  from PREFECTURE P
    left outer join HOSPITALIZATION H
      on H.PF_CODE = P.PF_CODE
order by 入院率 DESC, 都道府県コード