MySQL [Err] 1292 - Truncated incorrect DOUBLE value: '曹伟军'

Question

sqm_tbl表

sqm_fytj表

create table test as 
SELECT
    *
FROM
    (
        SELECT
            CURDATE() || '' AS 'balance_date',
            t.belonging_user || '' AS 'belonging_name',
            sum(t.total_deal_valid) AS 'total_deal_valid',
            FORMAT(sum(t.code_profit), 2) AS 'total_code_profit',
            sum(t.code_material) AS 'total_code_material'
        FROM
            sqm_tbl t
        GROUP BY
            belonging_user
    ) a
WHERE
    a.total_code_profit != '-';

是数据类型错误吗？
请赐教！