SELECT p.PF_CODE AS 都道府県コード,
p.PF_NAME AS 都道府県名,

TRIM(ROUND(
(cast(INP_YES as REAL)/(cast(INP_YES as REAL)+cast(INP_NO as REAL)+cast(UNIDENTIFIED as REAL)))*100
, 1), '.0') AS 入院率

FROM HOSPITALIZATION h
LEFT JOIN PREFECTURE p ON p.PF_CODE = h.PF_CODE

--ORDER BY '入院率' DESC, '都道府県コード' ASC
ORDER BY 入院率 DESC, p.PF_CODE ASC
;