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 NAME
2、
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)A1
Order by val desc limit 1
3、
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
1min目标场景问卷
立即参与
