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