SELECT 
    PF.PF_CODE AS 都道府県コード,
    PF.PF_NAME AS 都道府県名,
    CASE
        WHEN SUBSTR(CAST(ROUND(CAST(HS.INP_YES AS REAL)/(HS.INP_YES + HS.INP_NO + UNIDENTIFIED)*100, 1) AS text),-1,1) = "0"
            THEN SUBSTR(CAST(ROUND(CAST(HS.INP_YES AS REAL)/(HS.INP_YES + HS.INP_NO + UNIDENTIFIED)*100, 1) AS text),1,1)
        ELSE CAST(ROUND(CAST(HS.INP_YES AS REAL)/(HS.INP_YES + HS.INP_NO + UNIDENTIFIED)*100, 1) AS text)
    END AS 入院率
FROM HOSPITALIZATION AS HS
LEFT OUTER JOIN PREFECTURE AS PF
ON HS.PF_CODE = PF.PF_CODE
ORDER BY CAST(入院率 AS REAL) DESC, CAST(都道府県コード AS INTEGER) ASC;