sql - 每天对没有连接的多个表进行计数和求和

我要计算订单发票交付的数量，并合计每天的订单发票交付的数量。
像这样:

date  nb orders  orders$     nb delivery
day1     5        1234,56       3
day2     6        665,88        7
..

我第一次尝试此操作，一天没事，但一周没事，例如:

SELECT
  (SELECT COUNT(OPP.OPPNUM_0) FROM OPPOR OPP WHERE OPP.CREDAT_0=%1%),
  (SELECT SUM(OPP.OPPAMT_0) FROM OPPOR OPP WHERE OPP.CREDAT_0=%1%),
  (SELECT COUNT(SQH.SQHNUM_0) FROM SQUOTE SQH WHERE SQH.CREDAT_0=%1%),
  (SELECT SUM(SQH.YCUMHTSEL_0) FROM SQUOTE SQH WHERE SQH.CREDAT_0=%1%),
  (SELECT COUNT(SOH.SOHNUM_0) FROM SORDER SOH WHERE SOH.CREDAT_0=%1%),
  (SELECT SUM(SOH.ORDNOT_0) FROM SORDER SOH WHERE SOH.CREDAT_0=%1%)
FROM    dual

最佳答案

MySQL提供内置查询以按天过滤:

SELECT COUNT(*) FROM table_name WHERE anydatefiled >= NOW() - INTERVAL 1 DAY