3天&7天&&15天&销量如何统计同一行

Question

现有销售订单表salers_order_main 订单明细表salers_order_items_item 订单和明细之间可以通过order_id 可以关联需要查询统计近3天，7天 ，15天销量 需要汇总在同一行，看有更好的解决方案不
有参考这个https://www.sohu.com/a/731650439_121124359

Answer 1

试一试case when

SELECT
  CURRENT_DATE AS today,
  SUM(CASE WHEN soi.order_date >= CURRENT_DATE - INTERVAL 3 DAY THEN soi.quantity ELSE 0 END) AS sales_3_days,
  SUM(CASE WHEN soi.order_date >= CURRENT_DATE - INTERVAL 7 DAY THEN soi.quantity ELSE 0 END) AS sales_7_days,
  SUM(CASE WHEN soi.order_date >= CURRENT_DATE - INTERVAL 15 DAY THEN soi.quantity ELSE 0 END) AS sales_15_days
FROM
  salers_order_main som
JOIN
  salers_order_items_item soi ON som.order_id = soi.order_id
WHERE
  soi.order_date >= CURRENT_DATE - INTERVAL 15 DAY;