GA4 Sessions - Paul H.

SELECT
    COUNT(DISTINCT CASE WHEN event_name = 'session_start' THEN concat(user_pseudo_id, CAST(event_timestamp AS string)) END) AS sessions,
FROM
    `ventura-cluster.analytics_244044299.events_*`,
    unnest(event_params) AS param1
WHERE
    _table_suffix BETWEEN '20220501' AND '20220524' --start & end date
    AND param1.VALUE.string_value IS NOT NULL