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