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