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;