WITH RATE AS (
SELECT PF_CODE, ROUND(INP_YES * 100.0 / (INP_YES + INP_NO + UNIDENTIFIED), 1) AS RATE FROM HOSPITALIZATION
)
SELECT RATE.PF_CODE AS '都道府県コード', PF.PF_NAME AS '都道府県名', RATE AS '入院率' FROM RATE
INNER JOIN PREFECTURE AS PF ON PF.PF_CODE = RATE.PF_CODE
ORDER BY RATE DESC, RATE.PF_CODE ASC