Calendar days from transaction date to Form 4 filing date

SELECT
    multiIf(
        f.lag_days = 0, 'Same day',
        f.lag_days = 1, '1 calendar day',
        f.lag_days = 2, '2 calendar days',
        f.lag_days = 3, '3 calendar days',
        f.lag_days <= 7, '4 to 7 days',
        'More than 7 days')                             AS lag_bucket,
    count()                                             AS transaction_count,
    round(100 * count() / any(t.total_lines), 1)        AS share_pct
FROM
(
    SELECT dateDiff('day', transaction_date, filing_date) AS lag_days
    FROM global_markets.stocks_form4
    WHERE filing_date >= toDate('2025-08-01')
      AND filing_date <  toDate('2026-08-01')
      AND form_type = '4'
      AND transaction_date >= toDate('2025-06-01')
      AND transaction_date <= filing_date
) AS f
CROSS JOIN
(
    SELECT count() AS total_lines
    FROM global_markets.stocks_form4
    WHERE filing_date >= toDate('2025-08-01')
      AND filing_date <  toDate('2026-08-01')
      AND form_type = '4'
      AND transaction_date >= toDate('2025-06-01')
      AND transaction_date <= filing_date
) AS t
GROUP BY lag_bucket
ORDER BY min(f.lag_days)