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