SELECT
P.PF_CODE AS '都道府県コード',
P.PF_NAME AS '都道府県名',
'入院率' = ROUND((SUM(H.INP_YES) / (SUM(H.INP_YES)+SUM(H.INP_NO)+SUM(H.UNIDENTIFIED)))*100,1)

FROM HOSPITALIZATION AS H

INNER JOIN PREFECTURE AS P
ON P.PF_CODE = H.PF_CODE

ORDER BY '入院率' DESC,
H.PF_CODE ASC;