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