SELECT
  user_pseudo_id as anonymous_id,
  TIMESTAMP_MICROS(event_timestamp) as timestamp,
  count(
    DISTINCT CONCAT(
      user_pseudo_id,
      "-",
      (
        SELECT
          value.int_value
        FROM
          unnest (event_params)
        WHERE
          key="ga_session_id"
      )
    )
  ) as value
FROM
  `red-land-cotton-ga4.analytics_309366137.events_*`
GROUP BY
  1,
  2