select
 h.PF_CODE as 都道府県コード
, p.PF_NAME as 都道府県名
, round(cast(IFNULL(h.INP_YES,0) as real) / cast(IFNULL(h.INP_YES,0) + IFNULL(h.INP_NO,0) + IFNULL(h.UNIDENTIFIED,0) as real) * 100,1 ) as  入院率
from HOSPITALIZATION h
     left join PREFECTURE p
       on p.PF_CODE = h.PF_CODE
order by 入院率 desc
, h.PF_CODE