1、"SELECT t.statis_date AS CCOL1,SUM(t.amount2) AS CCOL2 FROM biz1d8vmyfwndbmrf9b7da2fohr5gh t WHERE 1=1 GROUP BY substring(t.statis_date,0,8) ORDER BY statis_date ASC LIMIT 100"; ...

CREATE TABLE IF NOT EXISTS rule_detect_suboptimal_join_order ( rule_id BIGINT, org_id TEXT, version_id BIGINT, project_name TEXT, log_id TEXT, user_name TEXT, query TEXT, left_table_database TEXT, ...