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