SELECT
PREFECTURE.PF_CODE as 都道府県コード,
PREFECTURE.PF_NAME as 都道府県名,
--ROUND(INP_YES/(INP_YES+INP_NO+UNIDENTIFIED)*100,2) as 入院率
--INP_YES/(INP_YES+INP_NO+UNIDENTIFIED)*100 as 入院率
ROUND(CAST(INP_YES AS FLOAT)/(CAST(INP_YES AS FLOAT)+CAST(INP_NO AS FLOAT)+CAST(UNIDENTIFIED AS FLOAT))*100,1) as 入院率
FROM HOSPITALIZATION
LEFT JOIN PREFECTURE
ON HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
ORDER BY 入院率 DESC,都道府県コード