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