我有这个查询,它基本上获取了客户过去一年和3个月的平均支出:SELECTSQL_CALC_FOUND_ROWScustomer_id,customer_name,AVG(IF(DATE(CONCAT(year_of_spend,"-",month_of_spend,"-01"))>=DATE_FORMAT(NOW()-INTERVAL1YEAR,"%Y-%m-01"),spend_amount,NULL))AS1_year_average_spend,AVG(IF(DATE(CONCAT(year_of_spend,"-",month_of_spend,"-01"))>=DATE_FO