select
b.PF_CODE as 都道府県コード,
b.PF_NAME as 都道府県名,
ROUND(100 * a.INP_YES / (a.INP_YES + a.INP_NO + a.UNIDENTIFIED), 2) as 入院率
from
HOSPITALIZATION a, PREFECTURE b
where
a.PF_CODE = b.PF_CODE
ORDER BY
都道府県コード