SELECT H.PF_CODE AS '都道府県コード',
       P.PF_NAME AS '都道府県名',
       ROUND(100.00*H.INP_YES/(H.INP_YES + H.INP_NO + H.UNIDENTIFIED),1) AS 入院率
  FROM HOSPITALIZATION AS H
LEFT JOIN PREFECTURE AS P
 ON H.PF_CODE = P.PF_CODE
ORDER BY '入院率' DESC, '都道府県コード' ASC;