select
HOSPITALIZATION.PF_CODE as 都道府県コード,
PF_NAME as 都道府県名,
round(cast(INP_YES as real) / cast((INP_YES + INP_NO + UNIDENTIFIED)as real)*100, 1) as 入院率

from HOSPITALIZATION

inner join PREFECTURE
on PREFECTURE.PF_CODE = HOSPITALIZATION.PF_CODE

group by HOSPITALIZATION.PF_CODE

order by 入院率 desc,
都道府県コード asc