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