select
  P.PF_CODE as '都道府県コード',
  P.PF_NAME as '都道府県名',
  round(H.INP_YES / cast(H.INP_YES + H.INP_NO + H.UNIDENTIFIED as REAL) * 100, 1) as '入院率'
  from PREFECTURE as P
       inner join HOSPITALIZATION as H
                    ON P.PF_CODE = H.PF_CODE
 order by
   round(H.INP_YES / cast(H.INP_YES + H.INP_NO + H.UNIDENTIFIED as REAL) * 100, 1) desc,
   P.PF_CODE asc
   ;