SELECT
    都道府県コード,
    都道府県名,
    ROUND(入院者あり*100/(入院者あり+入院者なし+不詳),1) AS 入院率
FROM
(SELECT
    HOSPITALIZATION.PF_CODE AS 都道府県コード,
    PREFECTURE.PF_NAME AS 都道府県名,
    cast(HOSPITALIZATION.INP_YES as REAL) as 入院者あり,
    cast(HOSPITALIZATION.INP_NO as REAL) as 入院者なし,
    cast(HOSPITALIZATION.UNIDENTIFIED as REAL) as 不詳
FROM HOSPITALIZATION LEFT OUTER JOIN PREFECTURE ON HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE)
ORDER BY
    入院率 DESC,
    都道府県コード