如何根据事件的日期,时间和持续时间检查SQL表中的平均并发事件？

SELECT AVG(concurrent_events) as average_concurrent_events
FROM (
  SELECT 
    event_date,
    event_start_time,
    event_end_time,
    COUNT(*) OVER (PARTITION BY event_date, event_start_time, event_end_time) as concurrent_events
  FROM events
  WHERE event_date BETWEEN '2022-01-01' AND '2022-01-31'
) subquery
WHERE event_date BETWEEN '2022-01-01' AND '2022-01-31';