查询连续交易五天的客户id 交易日期 交易金额

假设你的交易数据存储在一个表中，包含客户ID（customer_id）、交易日期（transaction_date）和交易金额（transaction_amount）等字段，你可以使用以下SQL语句查询连续交易五天的客户ID、交易日期和交易金额：

SELECT 
  customer_id, 
  transaction_date, 
  SUM(transaction_amount) AS total_amount
FROM 
  transactions t1
WHERE 
  EXISTS (
    SELECT 
      1 
    FROM 
      transactions t2 
    WHERE 
      t1.customer_id = t2.customer_id 
      AND t1.transaction_date = DATE_SUB(t2.transaction_date, INTERVAL 1 DAY)
  ) 
  AND EXISTS (
    SELECT 
      1 
    FROM 
      transactions t3 
    WHERE 
      t1.customer_id = t3.customer_id 
      AND t1.transaction_date = DATE_SUB(t3.transaction_date, INTERVAL 2 DAY)
  ) 
  AND EXISTS (
    SELECT 
      1 
    FROM 
      transactions t4 
    WHERE 
      t1.customer_id = t4.customer_id 
      AND t1.transaction_date = DATE_SUB(t4.transaction_date, INTERVAL 3 DAY)
  ) 
  AND EXISTS (
    SELECT 
      1 
    FROM 
      transactions t5 
    WHERE 
      t1.customer_id = t5.customer_id 
      AND t1.transaction_date = DATE_SUB(t5.transaction_date, INTERVAL 4 DAY)
  ) 
GROUP BY 
  customer_id, 
  transaction_date

该查询语句使用了子查询和EXISTS关键字，用于检查当前交易日期的前四天是否也有交易数据，如果都存在，则将该客户的ID、交易日期和交易金额进行汇总，并输出查询结果。