select 
  prefecture.pf_code as 都道府県コード, 
  prefecture.pf_name as 都道府県名, 
  ROUND(
      CAST(hospitalization.inp_yes as real)/ CAST(
        (
          hospitalization.inp_yes + hospitalization.inp_no + hospitalization.unidentified
        ) as real
      )* 100,
    1
  ) as 入院率
from 
  prefecture 
  inner join hospitalization on prefecture.pf_code = hospitalization.pf_code 
order by 
  入院率  desc;