回答:导出的excel有空格,所以会报错
回答:[图片]
回答:本地文件夹出现中文
回答:sql 的符号写错了
回答:插件没禁用,现在好了
回答:插件的问题
回答:substr(SPLIT(value,'/'),1,10)>='2021-02-01'substr(SPLIT(value,'/'),1,10)<='2021-02-28'
回答:1. Select name,sum(case when Type_nm='交易金额' then day_val end) / sum(case when Type_nm='交易笔数' then day_val end) avg_val from t_type_day group by NAME2. Select name from( Select name,sum(val) val from( Select name,`mon_val(当月累计值)` val from t_type_mon where Type_nm='交易金额' Union all Select name,day_val val from t_type_day where Type_nm='交易金额')A group by name)A1Order by val desc limit 13. Select name,val1 from( Select name, sum(case when Type_nm='交易金额' then day_val end) val1, sum(case when Type_nm='交易笔数' then day_val end) val2 from t_type_day group by name)A Where val2>100 order by val1 desc
68
68
148
10