select PREFECTURE.PF_CODE AS 都道府県コード, PF_NAME AS 都道府県名, round(INP_YES*100.0/(INP_YES+INP_NO+UNIDENTIFIED), 1) AS 入院率 from PREFECTURE join HOSPITALIZATION on PREFECTURE.PF_CODE = HOSPITALIZATION.PF_CODE order by 入院率 desc, 都道府県コード;