SELECT HP.PF_CODE AS 都道府県コード,
       PR.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 PR
       ON HP.PF_CODE = PR.PF_CODE
       
       ORDER BY 入院率 DESC, HP.PF_CODE ASC;