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