select PF_CODE as '都道府県コード', PF_NAME as '都道府県名', ROUND(INP_YES * 100.0 / (INP_NO + INP_YES + UNIDENTIFIED ), 1)  as '入院率' from HOSPITALIZATION natural join PREFECTURE group by PF_CODE order by 入院率 desc, PF_CODE;