SELECT 
HOS.PF_CODE AS 都道府県コード
,PREF.PF_NAME AS 都道府県名
,HOS.INP_PER AS 入院率
FROM
(
	SELECT 
	PF_CODE
	,CAST(CAST(INP_YES AS REAL) / CAST(INP_YES + INP_NO + UNIDENTIFIED AS REAL) * 100 AS INT) AS INP_PER
	FROM HOSPITALIZATION
) HOS
LEFT JOIN PREFECTURE PREF
ON HOS.PF_CODE = PREF.PF_CODE
ORDER BY INP_PER DESC, HOS.PF_CODE ASC;