SELECT main.PF_CODE AS 都道府県コード
      ,main.PF_NAME AS 都道府県名
      ,sub.rate AS 入院率
FROM PREFECTURE main
INNER JOIN
(
SELECT a.PF_CODE
      ,ROUND((CAST(a.INP_YES as REAL) / (a.INP_YES + a.INP_NO + a.UNIDENTIFIED)) * 100,1) AS rate
FROM HOSPITALIZATION a
)sub
ON main.PF_CODE = sub.PF_CODE
ORDER BY sub.rate desc
        ,main.PF_CODE