SELECT HOSPITALIZATION.PF_CODE,PF_NAME,round(INP_YES*100/(INP_YES+INP_NO+UNIDENTIFIED),2) FROM HOSPITALIZATION INNER JOIN PREFECTURE ON HOSPITALIZATION.PF_CODE=PREFECTURE.PF_CODE;