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