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