SELECT 
 L.PF_CODE AS 都道府県コード
 ,R1.PF_NAME AS 都道府県名
 ,ROUND(CAST(L.INP_YES AS REAL) / CAST((L.INP_YES + L.INP_NO + L.UNIDENTIFIED) AS REAL) * 100,1) AS 入院率
 FROM HOSPITALIZATION L
 INNER JOIN  PREFECTURE R1
 ON L.PF_CODE = R1.PF_CODE
 GROUP BY 1,2 ORDER BY 3 DESC,1;