INSERT INTO target_table (biz_date, county_name, depart_name, person_uuid, cust_code, cust_name, terminal_level_name, data_gather_type_name, sc_type_name, sc_score, sc_type_name_old, sc_score_old, up) SELECT a.biz_date, a.county_name, a.depart_name, a.person_uuid, a.cust_code, a.cust_name, a.terminal_level_name, a.data_gather_type_name, a.sc_type_name, a.sc_score, b.sc_type_name AS sc_type_name_old, b.sc_score AS sc_score_old, a.sc_score - b.sc_score AS up FROM ads_yh_yx_sctwo a LEFT JOIN ads_yh_yx_sctwo b ON a.cust_code = b.cust_code AND b.biz_date = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 5 DAY), '%Y%m%d') AND b.person_uuid = '00000000001389361632876_5304_371' WHERE a.biz_date = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 1 DAY '%Y%m%d') AND a.person_uuid = '00000000001389361632876_5304_371' AND a.sc_type_name != b.sc_type_name AND (a.sc_score - b.sc_score) <> 0 查找此sql的问题

根据你提供的SQL查询语句，我检测到以下问题:

1. 在第20行中，缺少一个闭括号")"来关闭DATE_FORMAT函数。
2. 在第21行中，AND a.sc_type_name != b.sc_type_name的条件可能导致不准确的结果。这将排除掉sc_type_name相同的记录。
3. 在第22行中，AND (a.sc_score - b.sc_score) <> 0条件可能导致不准确的结果。这将排除掉sc_score差值为0的记录。

修正后的SQL查询语句如下:

INSERT INTO target_table (biz_date, county_name, depart_name, person_uuid, cust_code, cust_name, terminal_level_name, data_gather_type_name, sc_type_name, sc_score, sc_type_name_old, sc_score_old, up)
SELECT
    a.biz_date, 
    a.county_name,
    a.depart_name,
    a.person_uuid,
    a.cust_code, 
    a.cust_name,
    a.terminal_level_name,
    a.data_gather_type_name,
    a.sc_type_name, 
    a.sc_score, 
    b.sc_type_name AS sc_type_name_old, 
    b.sc_score AS sc_score_old,
    a.sc_score - b.sc_score AS up
FROM ads_yh_yx_sctwo a
LEFT JOIN ads_yh_yx_sctwo b ON a.cust_code = b.cust_code 
    AND b.biz_date = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 5 DAY), '%Y%m%d')
    AND b.person_uuid = '00000000001389361632876_5304_371'
WHERE a.biz_date = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 1 DAY), '%Y%m%d')
    AND a.person_uuid = '00000000001389361632876_5304_371'
    AND a.sc_type_name <> b.sc_type_name
    AND (a.sc_score - b.sc_score) <> 0;

这将修复问题并执行正确的查询。请注意，我做出的更改可能仅限于语法修复，可能还有其他逻辑问题需要进一步检查。