SELECT 
PF_CODE AS 都道府県コード,
PF_NAME AS 都道府県名,
ROUND(CAST(INP_YES AS FLOAT) * 100 / (INP_YES+INP_NO+UNIDENTIFIED),1) AS 入院率
FROM HOSPITALIZATION
JOIN PREFECTURE
USING(PF_CODE)
ORDER BY 3 DESC,1;