SELECT HOSPITALIZATION.PF_CODE 都道府県コード, PF_NAME 都道府県名, ROUND( cast(INP_YES as real) * 100 / cast(( INP_YES + INP_NO + UNIDENTIFIED) as real ), 2 ) 入院率
FROM HOSPITALIZATION, PREFECTURE
WHERE HOSPITALIZATION.PF_CODE=PREFECTURE.PF_CODE
ORDER BY 入院率 DESC, 都道府県コード