SELECT
A.PF_CODE AS "都道府県コード",
A.PF_NAME AS "都道府県名",
ROUND((INP_YES*100.0)/(INP_YES+INP_NO+UNIDENTIFIED),1) AS "入院率"
FROM PREFECTURE A
LEFT JOIN HOSPITALIZATION B
ON A.PF_CODE = B.PF_CODE
WHERE 入院率 is not null
ORDER BY 入院率 DESC, 都道府県コード ASC