select pf_code                                                                                   as 都道府県コード,
       (select pf_name from prefecture where prefecture.pf_code is hospitalization.pf_code)      as 都道府県名,
       round(cast(inp_yes as real) * 100 / (inp_yes + inp_no + hospitalization.unidentified), 1) as 入院率
from hospitalization
order by 入院率 DESC;