SELECT
    H.PF_CODE AS '都道府県コード',
    P.PF_NAME AS '都道府県名',
    (H.INP_YES / (H.INP_YES + H.INP_NO + H.UNIDENTIFIED)) * 100 AS '入院率',
    H.INP_YES/(H.INP_YES + H.INP_NO + H.UNIDENTIFIED),
    round((cast(H.INP_YES as REAL) / cast(H.INP_NO as REAL) * 100) ,2) AS '入居率2'
FROM `HOSPITALIZATION` H
JOIN `PREFECTURE` P
ON H.PF_CODE = P.PF_CODE
ORDER BY '入院率' DESC, '都道府県コード'
-- ORDER BY (SUM(H.INP_YES) / (SUM(H.INP_YES) + SUM(H.INP_NO) + SUM(UNIDENTIFIED))) * 100 DESC, H.PF_CODE ESC
;