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