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