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