SELECT
	P.PF_CODE AS 都道府県コード
	,P.PF_NAME AS 都道府県名
	,round(cast(H.INP_YES as REAL) / cast((H.INP_YES + H.INP_NO + H.UNIDENTIFIED) as REAL) * 100, 1)  AS 入院率
FROM
	HOSPITALIZATION AS H
INNER  JOIN
	PREFECTURE AS P
ON
    P.PF_CODE = H.PF_CODE
ORDER BY
	入院率 DESC
	,P.PF_CODE ASC
;