validate-flights

WITH
  flights AS (
  SELECT
    DATE(event_at) AS dt,
    COUNT(*)
  FROM
    `reporting.flight_allocations`
  WHERE
    event_at > "2020-04-25"
  GROUP BY
    1)
SELECT
  *
FROM
  flights
ORDER BY
  dt