SELECT 
PF_NAME AS "都道府県コード",
ROUND(INP_YES / CAST((INP_YES + INP_NO + UNIDENTIFIED) AS FLOAT) * 100, 2) AS "入院率" 
FROM HOSPITALIZATION h
LEFT JOIN PREFECTURE p
ON h.PF_CODE = p.PF_CODE