select b.PF_CODE as 都道府県コード, b.PF_NAME as 都道府県名, round(cast(a.INP_YES as REAL) * 100 / (cast(a.INP_NO as REAL) + cast(a.UNIDENTIFIED as real)), 1) as 入院率 from HOSPITALIZATION  as a  LEFT JOIN PREFECTURE as b on a.PF_CODE = b.PF_CODE GROUP BY a.PF_CODE ORDER BY 入院率 DESC, 都道府県コード DESC;