SELECT ST_channel, ST_media_source, ST_campaign, MIN(DT_connection_start) AS FirstTime, MAX(DT_connection_start) AS LasTime, COUNT(*) AS Nb, COUNT(ID_player) AS NbPlayers FROM `fft-staging.dbt_v2_funbridge.stg_funbridge_connection` GROUP BY 1, 2, 3 ORDER BY 1, 2, 3;