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