已关闭。此问题需要details or clarity。目前不接受回答。
**要改进此问题吗？**通过editing this post添加详细信息并阐明问题。

两小时前关门了。
Improve this question的
我是一个很新的MYSQL，我有一个问题，我的查询，以显示究竟是什么，我需要使用它在PBI。
我有这个查询，我有开始和结束日期。它计算每周的活跃用户数，并返回每周的用户数开始的日期。我需要的是从我选择的开始和结束期间返回一个表，其中包含每周的数据。我在下面附上查询。

SELECT count(DISTINCT k.ID) as amount, won_accepted_date as dataa 
FROM Log_purchases,
     s_clients ak,
     s_bids k 
LEFT JOIN logistic_transport ON (k.auto_id = logistic_transport.transport_id)
WHERE k.bet_won = 1
  AND ak.ID = k.ID
  AND logistic_transport.transport_id IS NOT NULL
  AND k.auto_id = k.auto_id
  AND Log_purchases.company_id = logistic_transport.transport_id
  AND payment_type = '0'
  AND payment_damaged = '0'
  AND payed_for = '1'
  AND fault = '0'
  AND vat_pvm = '0'
  AND vat_compensation = '0'
  AND won_accepted_date >= '2023-09-18'
  AND won_accepted_date <= '2023-09-24'
  AND NOT EXISTS 
    (SELECT d.ID
     FROM Log_purchases,
          s_clients ak2,
          s_bids d
     LEFT JOIN logistic_transport
       ON (d.auto_id = logistic_transport.transport_id)
     WHERE d.bet_won = 1 AND ak2.ID=d.ID
       AND logistic_transport.transport_id IS NOT NULL
       AND d.auto_id=d.auto_id
       AND Log_purchases.company_id = logistic_transport.transport_id
       AND payment_type = '0' AND payment_damaged = '0' AND payed_for = '1' AND fault = '0'
       AND k.ID = d.ID AND vat_pvm = '0' AND vat_compensation='0'
       AND won_accepted_date<'2023-09-18'
     GROUP BY ID)

字符串
Example of what I need的
谢谢你的帮助！：）
不确定如何使用开始设置和结束函数。