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