SELECT
p.PF_CODE as 都道府県コード,
p.PF_NAME as 都道府県名,
round(cast(INP_YES as real)*100/(cast(INP_YES + INP_NO + UNIDENTIFIED as real)),1) as 入院率
FROM
HOSPITALIZATION h
INNER JOIN PREFECTURE p  ON h.PF_CODE = p.PF_CODE

GROUP BY 1,2
ORDER BY 3 desc, 1 asc