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