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