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