SELECT
	a.PF_CODE 都道府県コード
	, b.PF_NAME 都道府県名
	, round(CAST(a.INP_YES as real) / (a.INP_YES + a.INP_no + a.UNIDENTIFIED) * 100, 2) 入院率

FROM
	HOSPITALIZATION a
		LEFT JOIN PREFECTURE b
			ON a.PF_CODE = b.PF_CODE
ORDER BY
    入院率 DESC
	, a.PF_CODE
;