SELECT
a.PF_CODE as 都道府県コード,
b.PF_NAME as 都道府県名,
ROUND(a.INP_YES/(a.INP_YES+a.INP_NO+a.UNIDENTIFIED)*100,1) as 入院率
FROM
HOSPITALIZATION a
JOIN
PREFECTURE b
ON
a.PF_CODE = b.PF_CODE
ORDER BY 入院率 DESC,a.PF_CODE asc